Calculation in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a query that will:

Take a value from the previous day and calculate it with todays values....I
need to start with the date of "10/31/2000" and continue making the
calculations from that date on.

example: yesterdays' gas total + todays gas volume - todays gas withdrawl.
 
If it were me, I think I'd do this in XL. It would be easier. But if you use
Access I suggest that writing a 20-30 line module will be easier than
structuring a query (but then, I simply prefer the flexibility of modules
over the query grid). Good luck.
 
Back
Top