Extracting Fields from Multiple Tables

[Guest]

Suppose I have multiple different tables in my database, all with the left
most field as a date field, and multiple other fields for various different,
unrelated items.

How would I go about constructing a query to bring all these other fields
together under one field? Ideally, this new table would have four columns:
1) Autonumber ID, 2) Item Key (the name of the field from the other tables),
3) the date, 4) the data.

I would then like to save this table under a new name, and have it
regenerate itself everytime i add new data to the smaller other tables - this
isn't that important, however. The query is what I'm interested in, I just
dont know how i should go about programming it. I think it needs to be done
in VBA since DAO is required to get the name of the field, but I'm not sure.

Thanks,

 

[Guest]

To extract data from two table there must be common data between the two
tables. If all the two tables have in common it is a very poor database
structure.

You can build a query and join the two tables on their dates. Then you put
any or all of the fields in the output.