beginner question about a report

[eyhandle]

i have ten small tables for each state. i have ten reports. i would like to combine the ten tables by state into one report. what is the best way to do this?


NY NC

1 y 1 r
2 y 2 r
3 n 3 y

 

[PaulBricker]

You can add all ten reports to another main report to get them all together, or you should be able to create a Union Query that brings all the info into one query and then create the Report from there. The Union query will work if the field names for all your tables have the same fields.

Paul