Results 1 to 2 of 2
  1. #1
    dbh is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    3

    Query field displays zero but has a value when selected

    I have a relatively simple sets of tables for Expenses and Payments and about a dozen transactions are displaying as outstanding amounts in a query although the amount displayed is zero.

    The fields concerned are as follows:
    Total value of an expense.
    Code:
    Total: [AMOUNT]+[TAX]
    Total value of Paid To Date for the expense.
    Code:
    PTD: IIf([Q: Expense Payments (summary)].[Sum Of Amount]<>0,[Q: Expense Payments (summary)].[Sum Of Amount],0)
    Calculated Due Out value.
    Code:
    Due Out: [Total]-[PTD]
    So, although it's only a handful of records out of several thousand, this is what is happening:
    ID-14115
    Total [48.15]+[3.37]=51.52 (verified)
    PTD=51.52 (verified)
    Due Out=0.00

    So although the field is displaying a zero value when the field is selected, the actual value shows as '-7.105427357601E-15'. '-7.105427357601E-15' is actually always the value in the fields that show zero value for the handful of records.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please show table designs and related query SQL OR post a copy of the database(zip format) with a few records showing the issue.

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

Similar Threads

  1. Replies: 16
    Last Post: 02-07-2020, 11:42 AM
  2. Replies: 4
    Last Post: 07-27-2016, 12:07 PM
  3. Replies: 6
    Last Post: 06-23-2015, 06:58 PM
  4. Replies: 4
    Last Post: 07-27-2011, 09:52 AM
  5. Field displays number instead of value
    By rdueck in forum Reports
    Replies: 6
    Last Post: 02-25-2010, 08:19 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