E
efandango
I have a query that uses this lookup:
Expr1:
DLookUp("Timer_Elapsed","QRY_Run_Reveal_Timings","Run_waypoint_List_ID = " &
[Run_waypoint_List_ID])
the problem is that I get these kind of numbers returned:
Expr1
-9.25925924093463E-05
-2.31481462833472E-05
-4.62962998426519E-05
-3.47222157870419E-05
but the [Timer_Elapsed] field that the lookup references, returns these
correctly formatted numbers:
Timer_Elapsed
00:00:08
00:00:02
00:00:04
00:00:03
00:00:02
00:00:03
00:00:02
00:00:01
00:00:01
00:00:03
Expr1:
DLookUp("Timer_Elapsed","QRY_Run_Reveal_Timings","Run_waypoint_List_ID = " &
[Run_waypoint_List_ID])
the problem is that I get these kind of numbers returned:
Expr1
-9.25925924093463E-05
-2.31481462833472E-05
-4.62962998426519E-05
-3.47222157870419E-05
but the [Timer_Elapsed] field that the lookup references, returns these
correctly formatted numbers:
Timer_Elapsed
00:00:08
00:00:02
00:00:04
00:00:03
00:00:02
00:00:03
00:00:02
00:00:01
00:00:01
00:00:03