Hello
I want to know how I can combine records from a table field into one new field
So I have a unique id that sometimes is associated with the multiple records
For example
ID RECORD
N-7777 X
N-7777 C
N-7777 B
Is it possible to create a new calculated field in my query that would give me:
ID RECORD
N-7777 X, C, B
I dont know the SQL command nor how to create it if its possible.
Any help is much appreciative