Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    120

    Unanswered: Query Overflow Error

    I have a simple select query that I have 3 tables involved in.

    I am attempting to pull any that has a calculated field that is > 0.8.

    When I add this or a sort I get and error of Overflow and all the fields change to "Name?". If the sort or the critera are not there the query works fine or if I limit it to a single department within the query it works fine. If I attempt to query the entire table the error happens.

    I have not encountered this error before and have no idea what it means or how to fix it.

  2. #2
    Join Date
    Mar 2009
    Posts
    120
    I figured this out. There were several fields that had an error as there was no data to calculate, so I added an IF statement to the calculation and it solved my Overflow problem.

    THanks anyway!

Posting Permissions

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