Forum Discussion

andersammediase's avatar
andersammediase
Copper Contributor
Apr 13, 2023

Project of meterreadings and consumptioncalculation

Hi! I have for quite som time tried to learn Access. Im only at the base to create tables and so. The project I have been trying on and off, for some years now is a database that will keep track of ...
access
andersammediase's avatar
andersammediase
Copper Contributor
Apr 13, 2023

arnel_gp 

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_gp's avatar
    arnel_gp
    Steel Contributor
    Apr 13, 2023

    andersammediase 

    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.