Hi all!
In need of some more help....
I need to be able to join the contents of 3 different fields into one new field, as I'm trying to create call numbers, which are made up from the amalgamation of region_number, client_no and ref_no. (The rather deficient storing of this information necessitates me doing this). Would anyone know how to concatenate these three fields in Access? (I know it can be done in MS Excel using the CONCATENATE function to join information contained in cells....)
Many Thanks
Chris.
In need of some more help....
I need to be able to join the contents of 3 different fields into one new field, as I'm trying to create call numbers, which are made up from the amalgamation of region_number, client_no and ref_no. (The rather deficient storing of this information necessitates me doing this). Would anyone know how to concatenate these three fields in Access? (I know it can be done in MS Excel using the CONCATENATE function to join information contained in cells....)
Many Thanks
Chris.