Fstetson
New member
- Local time
- Yesterday, 23:44
- Joined
- Nov 12, 2020
- Messages
- 11
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
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
