Report Combonations

[cheiboy]

I keep a database and have maintained it for about 4 years now, some improvements over the years, no formal Access training in by background, I learned as I went.

Here's my problem. Recently, I added a whole new table, similiar to one that was already in the database, but the numbering sequence is totally different, all other fields are exactly the same. I have two totally seperate queries set up for each table, so every month, I'm having to run two separate reports to get the same info, is there a way to combine the two reports into one where the information is not duplicated or it giving me one or the other.

Thanks Much

Steve

 

[mpastore]

Why don't you UNION the two tables in a query and then base the report on the UNION query?

select * from table1 union select * from table2;

 

[cheiboy]

There are numerous tables, but the four I want to focus is on tblConcern (1a), tblMember(1b), tblUMConcern(2a) and tblUMMember(2b). The two concern tables have the same fields, but the primary keys are different, as is the two UM tables. They have their own queries respectively. Example, qryConcernReceived is pulled by using the Date received from 1a and 1b, and qryUMConcernsReceived information is pulled by using the Date Received from 2a and 2b. Can those two queries be queried and a report generated? This is just one of many reports generated and many other fields involved. Any ideas?

 

[cheiboy]

Additional note: tblConcern and tblMember are joined by the NewControl Number and tblUMConcern and tblUMMember have their own relationship using their own control numbers.