danikuper
Registered User.
- Local time
- Yesterday, 19:14
- Joined
- Feb 6, 2003
- Messages
- 147
I couldn't find a similar question already answered, so here it goes. I have multiple tables used to store information on different research materials:
table Books:
- BookID
- Author
- Title
- Year
- Cabinet
table Papers:
- PaperId
- Author
- Title
- Year
- Cabinet
table Catalog:
- CatalogID
- Author
- Title
- Year
- Cabinet
And I have a query for each of those tables that helps me find information. What I'm trying to do is to consolidate the result of those individual queries into one single query that later I can insert into a form to display a search result.
So the resulting query would look like:
Type.....ID....Author.....Title....Year....Cabinet
Book.....001...John.....Good book....2005....C01
Book....002.....Mary....Other book...2006...C01
Paper....001....Albert...PaperABC....1987....C01
Paper...002....John.....PaperXYZ.....2006....C02
Catalog...001...Mark....Cat00A....1989.....C02
Catalog...002...Bill......Cat00B.....2004.....C03
etc.
Is this possible?
Any help is appreciated!
Thanks.
Daniel
table Books:
- BookID
- Author
- Title
- Year
- Cabinet
table Papers:
- PaperId
- Author
- Title
- Year
- Cabinet
table Catalog:
- CatalogID
- Author
- Title
- Year
- Cabinet
And I have a query for each of those tables that helps me find information. What I'm trying to do is to consolidate the result of those individual queries into one single query that later I can insert into a form to display a search result.
So the resulting query would look like:
Type.....ID....Author.....Title....Year....Cabinet
Book.....001...John.....Good book....2005....C01
Book....002.....Mary....Other book...2006...C01
Paper....001....Albert...PaperABC....1987....C01
Paper...002....John.....PaperXYZ.....2006....C02
Catalog...001...Mark....Cat00A....1989.....C02
Catalog...002...Bill......Cat00B.....2004.....C03
etc.
Is this possible?
Any help is appreciated!
Thanks.
Daniel