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.
Expr1: DLookUp([CLOSING_VOLUME],[DAILY_TASK_WETSTOCK],("TANK_ID=" & [TANK_ID]) AND ([DATES]...