I'm trying to concatenate in one single record and field text from multiple records (one field) in a query. Normally it's not a problem to concatenate from the same record but can you do it from the same field in multiple records???
table with two columns:
can I get one table with two columns with ONLY one record reading
There is function in Access to group and Count, Sum and others but not concatenate. Is it even possible?