Creating a query for a report

[telcomwork]

I'm trying to create a query to be used by a report later. The output should display one instance of Event ID, Event Location as well as First and Last Name per each table. However when I group the Event ID and Event Location I still get multiple entries for a single event. Here is an example of what I'm talking about.

http://milletarypa.tripod.com/morehelp2.doc

Also I changed the Unique Values in the properties for the last blank cell to "Yes" adn still no luck.

Much thanks!

 

[GingerR]

Hi. If there are multiple people for each event, you will see each event multiple times. That's how queries work. But that is not necessarily how your report will be. In reports, you can format your query output to be how you want it. When you build the report, you can either:

1) Use the Sorting and Grouping functionality to make EVENTID a heading and put Event and EventID in the heading and the people in the Detail section, or

2) put all data in row-format in the detail section, sort by EventID, and set the "Hide Duplicates" property of the Event control to YES. This way each will only show one time, with a list of people underneath.

Hope this helps!


g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244