Simple query question.

[Bill Davis]

I have 2 database that I need to collect data from for
reporting db1.[currentdata] and db2.[currentdata]. How
can I create a query that will combine the two tables as
though it was one table.

 

[PC Datasheet]

Use an Union query. Check the Help file for union query. Looks like:
Select CurrentData
From Db1
Union
Select CurrentData
From Db2;

 

[Guest]

Thanks you..

-----Original Message-----
Use an Union query. Check the Help file for union query. Looks like:
Select CurrentData
From Db1
Union
Select CurrentData
From Db2;

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I have 2 database that I need to collect data from for
reporting db1.[currentdata] and db2.[currentdata]. How
can I create a query that will combine the two tables as
though it was one table.

.