By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Combine 2 tables into 1 virtual recordset

P: n/a
Red
So I inherited this db that has multiple 'orders' tables.
Each order table is name for the year of the orders...
i.e. 2005 is 'Orders-2005', 2006 is "Orders-2006"

So, I am not allowed to change the tables (boss likes how her stuff
works.. bleh...)... but I am being asked to created a way to show all
the orders from the last 12 montsh for a particular item, on demand.
Previously the db was just used for quarterly reports, but she wants
more...

So, without creating a temporary table, how can I combine the 2 tables
into a recordset in which I can query?

~Red

Feb 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Red a scris:
So I inherited this db that has multiple 'orders' tables.
Each order table is name for the year of the orders...
i.e. 2005 is 'Orders-2005', 2006 is "Orders-2006"

So, I am not allowed to change the tables (boss likes how her stuff
works.. bleh...)... but I am being asked to created a way to show all
the orders from the last 12 montsh for a particular item, on demand.
Previously the db was just used for quarterly reports, but she wants
more...

So, without creating a temporary table, how can I combine the 2 tables
into a recordset in which I can query?

~Red


Try with a union query.

Sebastian

Feb 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.