Copy data from tables..

[Patrick]

HI!
I'm looking for a way to program in VBA a series of copy
from different tables to a temp table.

I've got a total of 7 tables right now. Each one of them
are identical in the type of data the keep.

I want to cycle through all of them and pickup for example
all the vendor's names,clients name and Client ID.
And copy this info into my temp table.

After all the cycling is done I will print a report based
on the data inside my temp table.

And finnally,I will delete the data inside my table for
another use later on.

I can print and delete put could you let me know Of a way
to do my copying.

Thank you,

Patrick...

 

[Patrick]

Thank you very much its working.I never though that UNION
was good for this type of work.And no more temp table.
So can I make A UNION has complicated I it could be when
I'm just using a select for example. How far can I go,any
restrictions!!

THank again!

 

[TC]

(snip)

I've got a total of 7 tables right now. Each one of them
are identical in the type of data the keep.

You need to read this article:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC