Hi everyone,
I am setting a Database to keep track of daily water usage of 8 homes, each have their own independent meter and I have already setup a database with all daily readings for each home. I just need to create a calculation on daily water usage for a monthly report , the way we calculate water usage is meter reading from "Today" - meter reading from "yesterday" give us "yesterday's" water consumption. But I have no idea how to calculate this. Will really appreciate your comments.
Cheers
I am setting a Database to keep track of daily water usage of 8 homes, each have their own independent meter and I have already setup a database with all daily readings for each home. I just need to create a calculation on daily water usage for a monthly report , the way we calculate water usage is meter reading from "Today" - meter reading from "yesterday" give us "yesterday's" water consumption. But I have no idea how to calculate this. Will really appreciate your comments.
Cheers