If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtracting data for specific period of time
I have a table set up (based on an the old EXCEL spreadsheet we used prior to
this)and I would like to be able to have the total gallons used calculated from the beginning of a particular period to the end, by subtracting the starting H20Meter reading by the ending H20 Meter reading. This is how my table is set up: GWID-autonumber Date - Date/Time Employee, Text H20MeterReading - Number, long GPM - Number, long 24HRGAL-Number, long Is the query or report the place to do this. Please let me know what I need to do to fix this if I am wrong, etc. I am a newbie so please be gentle. Thanks |
#2
|
|||
|
|||
Yes, it's certainly possible to do this - just before we start. though, it's
not a good idea to call a Date field "Date" - although Access copes with it in most situations, sometimes it doesn't. It's also a bit confusing - it's much better to call the field "ReadingDate" or something more descriptive. OK, so what you're after is the latest reading minus the earliest reading within a given date period, yes? Or are you looking for the meter reading immediately before the beginning of your period (which is considerably harder) .. Also, does GPM identify each meter? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200510/1 |
#3
|
|||
|
|||
Answered in one of the other threads where you posted this q.
|
#4
|
|||
|
|||
Thank you for your reply and suggestion. Yes, I am looking for the meter
reading at the beginning of a particular period, say August 1st and the difference at the date I put in for the end, say August 31. I planned on writing a query whereby I would put the range of dates and the calculation would be made from the dates I put in. "David S via AccessMonster.com" wrote: Yes, it's certainly possible to do this - just before we start. though, it's not a good idea to call a Date field "Date" - although Access copes with it in most situations, sometimes it doesn't. It's also a bit confusing - it's much better to call the field "ReadingDate" or something more descriptive. OK, so what you're after is the latest reading minus the earliest reading within a given date period, yes? Or are you looking for the meter reading immediately before the beginning of your period (which is considerably harder) .. Also, does GPM identify each meter? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200510/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |