Access Report from one-many query 1

[kschomer]

I have an Employee and Geography tbl.
I want to report on information from both tables.
Terr Emp Name Ext States covered
123 Karen 999 AZ
CA
NM

234 John 777 VT
WV
PA
CAN I DO THIS? INSTEAD:
123 Karen 999 AZ, CA, NM
234 John 777 VT, WV, PA

 

[PPSAG]

sure you can do that. You'll need to structure the report to look the way you want. You'll need to join the tables to get the right info from the query.

 

[kschomer]

I do have the 2 tbls linked in a Query and the report is getting all fields (including State) from the query. But, I want the 1 State field (many relationship) to print the States left to right, with commas rather than by rows.