Help with errors in report (1 Viewer)

Fstetson

New member
Local time
Today, 08:56
Joined
Nov 12, 2020
Messages
8
I am trying to make a simple database structure to allow me to store monthly mileage readings. I am using a subquery to develop two fields "PriorValue" and "Mileage".
PriorValue being the last updated odometer reading and Mileage is calculated from current reading and prior value.

The query and subquery are working fine. It is in the report that I see #Error in both of these fields. I thought it as related to the Null fields created, but cannot figure out how to work around that. In VBA I would use a NZ() wrap-around. Need help in figuring this one out.

Attached database for reference
 

Attachments

  • Mileage.accdb
    536 KB · Views: 499

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:56
Joined
May 7, 2009
Messages
19,169
check and test.
 

Attachments

  • Mileage.accdb
    800 KB · Views: 471

Users who are viewing this thread

Top Bottom