Results 1 to 4 of 4
  1. #1
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81

    Question Using "Make Table" query versus "Select" query

    This is a pretty general question, but something I haven't quite nailed down yet..
    Is there a general rule of thumb, or best practices, on using a "Make Table" query (to then subsequently pull records from a temp table) versus simply using a "Select" query.



    For instance, suppose I have a large table of employee data, and am building a query that needs to pull a list of employees in certain job titles (and then join them to some other table with additional data).
    I could have a "Make Table" query dump those employees (with the specific job titles I'm interested in) into a temp table. Then, create a "Select" query by joining the Employee Record in my Temp Table to another table, etc.

    Or, I could change that "Make Table" query to a Select Query - again, including a condition to only include employees on those specific job titles. Then, create my final "Select" query by joining the Employee Record from that intial query to another table, etc.

    Does that make sense on what I'm asking?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Sort of.. but a sample of your data might help clarify things.

    If you have a table of Employee info and that table includes Job Titles, you could have a select query and a parameter
    [Enter Job Title] that could be used. The parameter value would be the different Job Titles to be selected.

  3. #3
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81
    Quote Originally Posted by orange View Post
    Sort of.. but a sample of your data might help clarify things.

    If you have a table of Employee info and that table includes Job Titles, you could have a select query and a parameter
    [Enter Job Title] that could be used. The parameter value would be the different Job Titles to be selected.
    I think I actually located a different thread - not this forum, but poses the same question
    https://stackoverflow.com/questions/...uery-in-access

    This somewhat clears it up for me!

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Yes it's similar. Final decision is based on your needs. Do you need to keep the Make Tables for some reason? Is there some sort of performance issue?

    Good luck with your project.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-06-2018, 08:26 PM
  2. Replies: 4
    Last Post: 12-20-2015, 12:16 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 1
    Last Post: 02-05-2015, 05:41 PM
  5. Replies: 1
    Last Post: 10-08-2012, 09:01 AM

Tags for this Thread

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