Separate tables - can you merge them?

[Guest]

I'm using three different tables from MS Query but I can't seem to merge
them. When I first tried to import them into access it wouldn't allow me to
add them to the same file - even though they have the same fields.

is there a way to merge separate tables in access?

thanks,
chris

 

[Ken Snell \(MVP\)]

Use an append query to copy the data from one table into another. Tha

 

[Guest]

Thanks Ken! I really appreciate the assistance. I'm still learning!!
Chris