Hi

     I have 2 tables, Now I need to combine these to tables as one table .Is there any method to do so?. eg: I have 2 tables table A and table B.now I want to create a table C which has all the fields of Table A and B including records.

pls help.

Using access queries.

Create a make table query using the results from your combined tables.

You can use a Union query to do this:

SELECT tblA.Field1, tblA.Field2
FROM tblA
WHERE tblA.Field1 <Some Criteria>
UNION ALL SELECT tblB.Field1, tblB.Field2
FROM tblB
WHERE tblB.Field1 <Some Criteria>;

In a Union query the total fields must be equal from each table (as above two fields requested) there are some variations in data types that can be combined. For more detailed info see "Combine data in fields from two or more tables using a union query" in Access help.

Kenny Alligood