Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Knowledgebase / FAQ _ Merging Multiple Queries into one Query.

Posted by: dallr Aug 12 2008, 08:07 PM

From time to time you find members asking how to merge or join multiple queries into one query. These are normally developers who started out by creating individual queries and then joining them to form a final query to return the result they want.Now as they got better at SQL writing they realized that they could have written those queries into one query instead. But although they know that the queries can be merged into one query they donít know how to do that.
Is such, this Access 2003 video tutorial shows a very simple technique on how to merge multiple queries into one query to reduce the amount of queries in your database. You can download the video from any one of the following two locations.
1. http://www.savefile.com/files/1723317
2. http://cid-d53090b128b32ae1.skydrive.live.com/self.aspx/Public/Merging%20Multiple%20Queries%20Into%20One%20Query.zip
After you download the video and extract it from the zip file open the file ca
Note:
1. This tutorial should not replace the knowledge a developer should acquire in trying to write queries from scratch and incorporating everything into one. But it acts more as a techinque to assist in the interim while the developer skills improve.
Dane