Combining 2 queries in one report

[David]

Using Access 2002. I've got a report that uses a query to show account
detail data. We have two separate types of accounts and each type has
it's own account history table. The query/report has always just used
one of the account types but now needs to include the other type as
well. Many of the fields that are used in the report are the same in
the second set of accounts, but some are not.

How can I combine the two queries so that they are used in the same
report?

Thanks,

David

 

[Jeff Boyce]

David

Are you saying that the reports only use "common" fields (i.e., you aren't
using a field that is unique to one type of accounts)?

It sounds like you could use a UNION query to return all account
information, then use that UNION query as the source for your report.

A UNION query generally looks like:

SELECT something FROM sometable WHERE someconditions
UNION
SELECT same-somethings FROM anothertable WHERE someotherconditions;

Check Access HELP for more...

Regards

Jeff Boyce
Microsoft Office/Access MVP