Forum Discussion
Project of meterreadings and consumptioncalculation
Thanks a lot! Now I will try to read and understand what the different parts do.
And then start working on an invoice for each estate based on those numbers.
Another question. If I have waterprice in a table to take the cunsumption times waterprice, lets say it is£12 at this reading.
If we later raise the prise to £14 will that affekt the old invoices to, which are already billed?
Should I make a tblWaterPrice WaterpriceID, WaterPrice, FromDate, ToDate?
To be able to keep track and to have the old ones show the right price if someone asks for a copy?
Am I thinking wrong here?
- arnel_gpApr 13, 2023Steel Contributor
you can use FromDate and ToDate to your WaterPrice.
you can also use only one Date, EffectiveDate (see the tblWaterPrice on the demo).
see Query1 and Query4 on how to get the WaerPrice.