Simple query question.

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

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.
 
Use an Union query. Check the Help file for union query. Looks like:
Select CurrentData
From Db1
Union
Select CurrentData
From Db2;
 
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.
Click to expand...


.
Click to expand...
 

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

SQL to find FileNum in one table not in another 2
Interesting Question 4
Adding New Record to a linked table from Query 1
Access Access Daisy Chain Linked Tables 0
Using 'Like' to query related fields between tables 2
query across two access databases 5
Schedule Update Query 1
SQL Query to copy Data from One Table to another Table having same names but from different database 1

Back
Top