Find date of added data

[JohnVogel]

I'm designing a fuel inventory system in access allowing one to enter pump and tank information in a gas station... I have several fields for various tank measurements, and pump readings. In the tank measurements I have a field for water measurement, which tells how much water is in the fuel (if any). The water measurement is being done once a month (per EPA specs), and the actual stick readings (How much fues in in the tanks) is being done every day. On my main monthly inventory worsheet, it shows the amount of fuel pumped, per day vs the amount read from pump (check for shortages)... I have it so that I can get all records for whichever month, show all the figures etc.. no problem (well, took a while, but yea ) now, the only problem I seem to be having is in getting it to display the water reading and date of reading.

I have the water reading in the main reading form, and have access to the information theough the readings table, what I need to know is how to do I pull JUST the water readings from a certain month, and display this information and the date it was entered?

Hope that wasn't toooo much information for a simple question, but I like to explain things thouroughly, if possible, so that you can "see" where I am coming from



John Vogel
john@thecompuwizard.com

http://www.thecompuwizard.com

 

[willir]

John

Is this just a calcualtion?

You have monthly "water" readings. Is this expressed as a percentage in the gas? If so, or some variation, you can use a calculated field on the form or report.

Calculate the monthly gas consumption, perhaps with DSUM.
Multiply or manipulate the value with water value measured for the month.

MyWater = Monthly_Gas * Water_in_Gas_percentage

 

[JohnVogel]

Thank you for your reply. The problem is that there is only one day of the month that the water reading is done, and it is only one reading. However, it's not always done on the same day of the month. On the monthly form it looks something like this:

Tank ID [ ]
Month/Year[ ]/[ ]
Date of Water Check [ ] Level of Water(inches)[ ]

xxxxx xxxxx xxxxx xxxxx xxxxx
1 [ ] [ ] [ ] [ ]
2 [ ] [ ] [ ] [ ]
3 [ ] [ ] [ ] [ ]
4 [ ] [ ] [ ] [ ]
5 [ ] [ ] [ ] [ ]
...

the information (1..2..3..4..) is for each day that there was fuel pumped. There should be a record for every day the place was opened that month. The water check (as I said above) is done only once per month, and is shown at the top of the form, beside the date of water check.

The question I have is... how do I isolate just that one record of the water check per month and put that on my form.

Thanks


John Vogel
john@thecompuwizard.com

http://www.thecompuwizard.com