Hi,
I am a beginner in access.
I have several access files. They all contain only 1 table inside named table1. In this table, there are 9 text fields with millions of entries.
In table1, the first 3 fields are named "ID1", "ID2", "ID3".
The other fields are named "Valeur1", "Valeur2", "Valeur3", "Valeur4", "Valeur5", "Valeur6".
I need to concatenate the fields "ID1", "ID2", "ID3" to build one and only "ID" field which will contain unique values.
We should get the values in the "ID" field by concatenating the values of "ID1", "ID2", "ID3" using this format : ID1_ID2_ID3 which means that the value in "ID1" field should be followed by "_" followed by the value in "ID2" field followed by "_" followed by the value in "ID3" field.
The other fields "Valeur1", "Valeur2", "Valeur3", "Valeur4", "Valeur5", "Valeur6" should remain unchanged.
I have been told it was easy to do but I have googled a lot about that and I still can't find how to do that.
Can anyone help me please?
Thank you
Nicky