Multiple records. (1 Viewer)

[bowldog]

I have a query with District,Name,Position.The Position field has multiple contacts(Program,Primary,Secondary). My query results are correct(District,Name,Position) but there are three records. Can I get the Names and Positions in one record for each district? Any help is greatly appreciated.

 

[Pat Hartman]

Look up this article:

Q141624 - ACC How to Concatenate a List of Items from a Many-Side Table