Results 1 to 2 of 2

Thread: Help with Query

  1. #1
    Join Date
    Sep 2005

    Unanswered: Help with Query

    I have a table with among other fields, a division field and a commodity field. There are 3 division categories and several commodity categories. I have a query for each combination of division/commodity. Some queries return as few as one record, while some return as many as 20. Each record has a dollar amount, which is totaled. I have created another query, a "master" query, which brings all of the queries into one recordsource. The problem I'm running into is when I run this query, those queries with one record repeats itself as many times as the query with the most records. In other words, the query with one record of 10.00 gets repeated 20 times (query with maximum number of records has 20), and get a total of 2,000.00 for my query with one record, instead of 10.00 like it should be. What I'm trying to accomplish is to have the total of each of the queries show up in the "master" query. Hope this makes sense. If anyone can help, I'd appreciate it.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Without seeing how the query are written (i.e. SQL expressions), it's almost impossible to provide sensible advice.
    Have a nice day!

Posting Permissions

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