Results 1 to 2 of 2
  1. #1
    Dave_D's Avatar
    Dave_D is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    67

    Query order


    This is just for my own reference. You have this DB where you develop many queries. How does access determine which of the queries it executes upon first..second..and so on or does it? Say you have 3 queries. The second query is designed solely on the results of the first and the result of the third is based upon the second. Without using a DoCmd OpenQuery, how does access know which query needs to executes in the proper sequence?

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Microsoft Access uses JET as its database engine. See here for a description: https://en.wikipedia.org/wiki/Micros...atabase_Engine

    If you have queries that call queries, I believe that it will "optimize" it and decide the most efficient way to do it. You usually don't need to worry about that part of things.
    If you have queries that call other queries, it will do all that automatically. You don't need to worry about that (provided you wrote them correctly). Typically, you only need to open the last one.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-07-2016, 05:02 PM
  2. Replies: 3
    Last Post: 02-09-2016, 04:36 PM
  3. How to order columns in ascending order?
    By darkingthereturn in forum Access
    Replies: 5
    Last Post: 06-18-2012, 05:24 AM
  4. Query for nonreturned order
    By lizzywu in forum Queries
    Replies: 10
    Last Post: 01-28-2012, 11:32 AM
  5. Query results order
    By Costa in forum Queries
    Replies: 6
    Last Post: 02-24-2010, 06:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums