Hi all,
I am having some trouble retrieving data from a query in the format I want it. I have a query where for each record there are 52 fields. Only three or four of those 52 fields actually have some data in them, the rest are empty. I need to set up a calculated field that will join the data from the columns that are not empty, but I cannot work out how to place a separation space between the data.
I think an example may be in order here:
Record 1: MU-103 EN-205 LE-303
When I join these three columns in my calculated field I get:
MU-103EN-205LE-303
But what I would like to get is: MU-103 EN-205 LE-303
or even better: MU-103/EN-205/LE-303
Any suggestions would be very much appreciated.
Thanks,
Pino
I am having some trouble retrieving data from a query in the format I want it. I have a query where for each record there are 52 fields. Only three or four of those 52 fields actually have some data in them, the rest are empty. I need to set up a calculated field that will join the data from the columns that are not empty, but I cannot work out how to place a separation space between the data.
I think an example may be in order here:
Record 1: MU-103 EN-205 LE-303
When I join these three columns in my calculated field I get:
MU-103EN-205LE-303
But what I would like to get is: MU-103 EN-205 LE-303
or even better: MU-103/EN-205/LE-303
Any suggestions would be very much appreciated.
Thanks,
Pino