UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> Merging Multiple Queries into one Query.    
 
   
dallr
post Aug 12 2008, 08:07 PM
Post#1


UtterAccess VIP
Posts: 3,078
Joined: 4-November 04
From: The Land of the Access Ninja's


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. SavFile.com
2. SkyDrive
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
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 11:30 PM