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

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!

>-----Original Message-----
>Hi Patrick,
>
>Not sure if I understand this...are you, in essence,
>trying to make a 'master' list? So, you'll want a
listing
>of all the vendor_names, client_names, and client_ids (no
>duplicates). If so, I think your best bet would be a
>UNION query...if you want to keep all the duplicates, use
>a UNION ALL. Something like so:
>
>Select vendor_name, client_name, client_id from table1
>UNION
>Select vendor_name, client_name, client_id from table2
>UNION
>Select ......and so on for the rest of the tables;
>
>I wouldn't necessarily be copying this data into another
>table unless it's absolutely necessary (in which case you
>can use a make-table query). You can use this query as
>your recordsource for your report.
>
>Regards,
>Jen
>
>
>>-----Original Message-----
>>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" <(E-Mail Removed)> wrote in message
news:07f301c37231$be1ea830$(E-Mail Removed)...
(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...es/Q100139.ASP

HTH,
TC