Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013

    Unhappy Unanswered: Missing records from a simple calculation query


    I've been working on a query to calculate the total of several fields for each of my records.

    I don't have any filters running all the query does is simply pull up the information and add the calculated field -- or at least that's what I want it to do.

    It does do the calculation, but for some reason out of my 564 records, it only does this for 268 records and I can't seem to fathom why its not showing them all?

    I've checked my records to check for blank fields and there are none.

    Any advice or guidance you can provide would be greatly appreciated.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    please post the query's SQL

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