Access [Archive] - ForumsHQ

[Speed]

I know some of you work with Access day in and day out. I need to know how to do somethin, I can't f'kin figure it out. I have about 40 tables that I want to merge together into one giant table. How the hell do I do that? I keep an inventory of stuff in my warehouse, and each set of items had an order number. I separated everything by order number in Access. Now I need a full tally of everything I have, and I need it sorted, but I can't find how to do it. The only thing I've found I can do is copy each table, and paste append it into a new table. That takes a while with 40 tables, and since I get more tables every day, it's not going to be efficient later. I attached a screen shot of the tables. I need everything starting with 48 merged together into one big list. Any ideas?

[elpresidente]

have u tried the wizard?

[Speed]

The wizard blows. Microsoft blows.

[Ark]

Pray thee unto Zeus, sacrifice a virgin lamb unto His glory, and beg for knowledge to unravel Microsoft's mysteries.



Or cut n paste the tables individually (that'd only take all day) :P



- Ark