How to combine data in multiple tables for reports

[Guest]

I am working with a database that has mutiple tables. I am trying to figure
out the best way to gather the data for reporting. I thought that I could
simply do a query adding in all the tables and selecting the fields I would
want to show on my report.

The problem I have as you probably already know is this creates duplicate
records.

What is the best way to combine all this data?

Much thanks in advance!

 

[Guest]

You can use grouping in reports to eliminate duplicates that appear in the
source query. Also, text boxes include a property named "Hide Duplicates" on
the Format tab of the Properties dialog, when the text box in question is
selected. Use View > Properties to display the Properties dialog.

For more information on grouped reports, see to sub-topic "Types of Reports"
in this article:

http://office.microsoft.com/en-us/access/HA011549641033.aspx


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________