G
Guest
hey
I have 42 Tables and i am looking to combine them into one MASTER table
there are 4 common field i am looking for.
There is the long way of doing this running 42 queries. I have that set up
but figure there is a better way.
I want the query to grab table 1 input the 4 fields into the MASTER Table,
when complete go to table 2 and do the same thing automatically. AS well i am
forcing the table name into a column in thet MASTER Table. Can this be added
into the query.
If the query has to prompt me or have me select which table is next i can
live with that no problems.
Any idea? Does anyone have something like this i can modify to fit my work
Let me know
thanks
I have 42 Tables and i am looking to combine them into one MASTER table
there are 4 common field i am looking for.
There is the long way of doing this running 42 queries. I have that set up
but figure there is a better way.
I want the query to grab table 1 input the 4 fields into the MASTER Table,
when complete go to table 2 and do the same thing automatically. AS well i am
forcing the table name into a column in thet MASTER Table. Can this be added
into the query.
If the query has to prompt me or have me select which table is next i can
live with that no problems.
Any idea? Does anyone have something like this i can modify to fit my work
Let me know
thanks