How to combine data in multiple tables for reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining multiple reports 1
Combine multiple tables into one 8
Combine multiple reports 2
Same record/Primary key in multiple tables 0
How do i combine two reports into one report? 3
Combine data in two records from same field 16
Access Sorting and grouping using multiple tables 0
How to copy aQuery to a new Table? 3

Back
Top