Hi,
New user here and I have tried researching my problem but cant seem to get an answer.
Background:
I have a tank of gasoline which I need to monitor the sales from. I need a report at the end of the month showing how much I am short or over in gallons on a daily basis. I would also need the total over/short for the whole month (ie the summation of the daily over/short).
I have a table called Canoga. It has the following columns:
Date Volume Sales
10/1/11 600 80
10/2/11 540 70
10/3/11 500 25
and so on
The volume is the closing volume at the end of the day.
So beginning with 10/2/11 I need a report showing the above data plus an over/short column.
For 10/2/11 it would say -10 (=600-540-70)
For 10/3/11 it would say +15 (=540-500-25)
So far the approach I tried is using dlookup in a textbox and pulling the previous days volume by matching the dates minus 1
Please help, I've gone all over the internet looking for an answer but had no luck.