MERGE 2 DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i HAVE 2 DB WITH THE SAME FIELDS, NO AUTONUMBERS, I HAVE TO MAKE A REPORT
EACH MONTH ON ITEMS RECIEVED FROM BOTH THESE DB, INTO 1 REPORT NOT 2 SEPERATE
ONES. CAN YOU HELP ME ?
 
Please find and use your shift key. Typing in all CAPS is considered
shouting and is difficult to read.

I assume you have 2 "tables" not "DB" with the same fields. You can use a
union query to combine the tables into a single record set.

SELECT FieldA, FieldB, FieldC,...
FROM tblOne
UNION ALL
SELECT FieldA, FieldB, FieldC,...
FROM tblTwo;
 
There is nothing in Access that is known as "DB". Access is a Database
program. If you don't have any tables then I'm not sure why you are even
asking a question in mp.access.queries.

If you actually do have something like tables, did you attempt a union
query? If so, what were your results?
 
Back
Top