Results 1 to 3 of 3
  1. #1
    inhops is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Posts
    13

    Minimum from muliple tables


    I have a query that is working, but I am looking to make it faster. We import 13 csv files daily into 13 Access tables. The files have an ItemID and price. We need to get the minimum of the raw data across the 13 tables & then manipulate the prices some (in the query) and get the lowest of the manipulated prices again for the 13 tables for each ItemID - some might be blank. We are using a MinOfList function in the query to get the minimum of the 13 numbers. But this is very time consuming since we have to run the Min function twice (with 13 input parameters) for each ItemID - about 15,000 records. It takes about 1 minute to run the query. Any thoughts on how we can streamline this? Thanks for your help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Why do you have 13 tables? Could you please tell us more about the application, the csv's, and the tables. It sounds like there may be more to the story than what you have told us.

  3. #3
    inhops is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Posts
    13
    The CSV files are exported/created from another program which parses data from 13 different websites - SKU and current price. We then import these 13 files into Access to find the "best" price - some of the prices will be "thrown out" i.e. not used. Then we need to determine the lowest of the good/remaining prices.

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

Similar Threads

  1. Identify and Assign Value to Minimum
    By 0REDSOX7 in forum Access
    Replies: 2
    Last Post: 10-29-2012, 08:20 AM
  2. Criteria for a minimum itself
    By hawkins in forum Access
    Replies: 17
    Last Post: 07-27-2011, 12:57 PM
  3. Can't see minimum or maximum buttons?!?
    By Felix_too in forum Forms
    Replies: 2
    Last Post: 12-29-2010, 10:04 AM
  4. Data from muliple tables
    By carstenhdk in forum Queries
    Replies: 3
    Last Post: 06-08-2010, 10:35 AM
  5. Muliple If, Then Statements
    By jrockusa in forum Access
    Replies: 2
    Last Post: 12-06-2009, 11:06 PM

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