Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Whittier, California, USA
    Thanked 0 Times in 0 Posts

    Slow Sum Query (2003)

    Hello All,

    I have created queries that group records into several categories and then sum a field. The data comes from a text file that I import into Access. The queries link string fields in the main table to other tables in order to group the results into the categories that I want. The problem is that these queries run very slowly or sometimes not at all, depending on how many different fields I need to group by.

    I am considering writing some code that would add the integer ID's that match the string fields to the main table, and then run the queries. My hope is that grouping by integer fields will go faster than by strings. Is this theory correct?



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Slow Sum Query (2003)

    Matching on a number field is more efficient than matching on a text field.
    Also, make sure that your tables are indexed on the fields on which you link them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts