HELP ME!!!!

[Guest]

I have several tables with different categories in each one that need to be
combined into one master table. how do i do this without just retyping the
information over in a new table? there are over 2,000 entries all together i
don't want to do this manually.

 

[Guest]

Lori,

It certainly can be simple to do what you intend, however it's impossible to
advise you how without knowing the structures of the tables. Please post
their fields and fieldtypes and we can help.

Sprinks

 

[John Vinson]

I have several tables with different categories in each one that need to be
combined into one master table. how do i do this without just retyping the
information over in a new table? there are over 2,000 entries all together i
don't want to do this manually.

Please don't yell, Lori. Most people who post here want help; we
realize that, it's why we spend our time volunteering. A simple "How
do I combine tables?" as a subject line will get you answers just as
fast.

To answer - it sounds like one or more Append queries would be useful.
As Sprinks suggests, we'd better be able to help you if we knew what
you are working with; *you* can see your computer - we cannot.

John W. Vinson[MVP]