Bob has attended:
Access Intermediate course
Concatenation
Got a DB with 3 columns
Col 1 = ID (unique value)
Col 2 = Agent Name (Unique value)
Col 3 = Postcode (multiple values)
ie: 1 Postcode is covered by many agents...
How can I concatenate Col 1 & 2 into single Postcodes
ie:
001, 002, 003 Fred Smith, Jim Hall, Pat Jones TW8 8JA
Many thanks
RE: Concatenation
Hi Bob
Sorry for the delay.
Do you need to have the IDs, Agent names and postcode appear as a new value?
If not you could do a query that just concactenates the ID and Agent name for each record and then create a report that shows all agents grouped by Postcode
To Concactenate in a Query:
In a new field in the Query window
Open the Build window - Right click Select build
Enter the following code:
FullAgent: [ID field] + "," + [Agent name field]
Hope this helps.
Regards
Carlos
