Hello,
I need to display closing volume value where the date is one day prior & tanks are equal to the current record tank ID. Help is appreciated.
Heres what I have, but I can't seem to get it working.
I need to display closing volume value where the date is one day prior & tanks are equal to the current record tank ID. Help is appreciated.
Heres what I have, but I can't seem to get it working.
Code:
Expr1: DLookUp([CLOSING_VOLUME],[DAILY_TASK_WETSTOCK],("TANK_ID=" & [TANK_ID]) AND ([DATES] = # & [DATES] & #-1))