Combine queries
Good morning!
I have several queries that I want to create a new query from, but not a normal query.
What I want the query to do is pull all the records from all tables and list them kind of like one big table. All the fields in each table are named identical. The only reason I have them in separate tables, is that I want the autonumber field to start over each year. So I have a table for each year.
For instance:
The field names are reportnumber, initiator, date, title...and so on.
Query 1
02-0001 J. Doe 1/3/02 Scrap report
02-0002 D. Miller 4/7/02 Cost reduction report
Query 2
03-0001 J. Doe 6/3/03 Engineering theories
03-0002 D. Miller 8/24/03 Lean Implementation
New Query (This is what I am wanting to know how to do)
02-0001 J. Doe 1/3/02 Scrap report
02-0002 D. Miller 4/7/02 Cost reduction report
03-0001 J. Doe 6/3/03 Engineering theories
03-0002 D. Miller 8/24/03 Lean Implementation
Not like this
02-0001 J. Doe 1/3/02 Scrap report 03-0001 J. Doe 6/3/03 Engineering theories
02-0002 D. Miller 4/7/02 Cost reduction report 03-0002 D. Miller 8/24/03 Lean Implementation
Any help would be greatly appreciated.
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
__________________
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
|
