 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007Combining Queries
I have several queries which are identical in structure and use the same field names except for one field that uses an expression (the expression is what makes the queries different). How would I create another query that combines these queries back together again? One more thing... I would like to accomplish this (if possible) without creating new tables or appending records. suggest you read up on Union queries in Access Help, to see if that will suit your purpose. hth > One more thing... > > I would like to accomplish this (if possible) without creating new tables or > appending records. SELECT A.* FROM Query1 A UNION ALL SELECT A.* FROM Query2 A etc Pieter > One more thing... > > I would like to accomplish this (if possible) without creating new tables > or > appending records. > I have several queries which are identical in structure and use the same > field names except for one field that uses an expression (the expression is > what makes the queries different). > > How would I create another query that combines these queries back together > again Why not just make one query that has all of the expressions in the same query instead of many queries? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.