how can i merge three diffrent table into one table

[Guest]

I HAVE THREE DIFFRENT TABLE I WANT TO MERGE TO WHOLE DATA IN ONE TABLE & THAN
MAKE A ONE OF QUERY (WHICH I KNOW HOW TO MAKE) & MALE REPORT FOR ALL DATA

THANKS & REGADRS
ANKIT PANCHAL
INDIA

 

[Joseph Meehan]

I HAVE THREE DIFFRENT TABLE I WANT TO MERGE TO WHOLE DATA IN ONE
TABLE & THAN MAKE A ONE OF QUERY (WHICH I KNOW HOW TO MAKE) & MALE
REPORT FOR ALL DATA

THANKS & REGADRS
ANKIT PANCHAL
INDIA

Are all the fields in all three tables identical in name and properties
(that is are they the same type [text, number, date etc.] and the same size?
If so you can use and append query.

You may run into problems if there are duplicate data in more than one
table.

-- I suggest that you disengage the CAPLOCK key. It is considered bad
form (like shouting) to use all caps and it makes it harder for most people
to read.