MERGE 2 DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAWHELP - 26 Jul 2006 21:48 GMT

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 ?

Reply to this Message

Duane Hookom - 26 Jul 2006 21:54 GMT

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;

Signature

Duane Hookom
MS Access MVP

>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 ?

Reply to this Message

DAWHELP - 26 Jul 2006 22:24 GMT

I have 2 DB not tables. Sorry for caps, my work here is done in all caps. so
sorry

> Please find and use your shift key. Typing in all CAPS is considered
> shouting and is difficult to read.
[quoted text clipped - 12 lines]
> > SEPERATE
> > ONES. CAN YOU HELP ME ?

Reply to this Message

Duane Hookom - 27 Jul 2006 02:47 GMT

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?

Signature

Duane Hookom
MS Access MVP

>I have 2 DB not tables. Sorry for caps, my work here is done in all caps.
>so
[quoted text clipped - 17 lines]
>> > SEPERATE
>> > ONES. CAN YOU HELP ME ?

Reply to this Message