Making a Calc Based On A Table

[scubagal]

Hello everyone. I am very new to databases, may have bitten off more than I can chew, but I was tried of working in 4 different spreadsheets and decided to pull them all into a database so that I could get what I wanted when I wanted. Here is what I need to be able to do: In a table I have 3 different industries entered 5 different times. They all cover a Monday to a Friday. Each day for each industry I record a reading from a meter. I make a calculation by subtracting Mondays number from Tuesadays, Tuesday from Wednesday, Wednesday from Thursday and Thursday from Friday. This calculation gives me how much water each industry used each day, over 24 hours. Doing this in a spreadsheet was simple. My table has the Industry name, date, previous day meter reading, present day reading. I want to have the calc show in my query. How do I set up this calculation. Any help would be greatly appreciated. Thank you. I attached a sample database that contains the table and query.

 

[EMP]

My table has the Industry name, date, previous day meter reading, present day reading

Since the meter readings of the previous day and the present day are in each record, in the query you can simply deduct the previous day reading from the present day reading, i.e. put this in the field row of a new column in the query grid:-

Usage: [present day meter reading] - [previous day meter reading]

^

 

[scubagal]

I had thought of that, but will I have to create a separate query for each and every industry? I print a report every month and would prefer to have one instead of 13.

 

[neileg]

One query will return all 13 records.