Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

INSERT 109 different fields from 28 tables - to one table

Status
Not open for further replies.
cuok

cuok

Programmer
Dec 24, 2001
201
I have to collect 109 different fields (laying on NONidentically structured tables) from about 28 tables - to one table (already I made of those fields).

What I'm doing now –in aim to fill this table- is by putting a code behind each one of those 109 fields on "AfterUpdat" event to add those field to this table.

All the 28 tables have the same ID and DtaeCheck as PK – the one field only have the ID as “duplicate / YES”

I'm Wondering if someone can help me with an idea how to do this mission automatically?


thread701-465651 dealing with identically structured tables.

Many thanks

CUOK
 
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
606
mikrom
mikrom
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
760
Andrzejek
Andrzejek
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
7
Views
274
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top