Recent content by riverwatch

Thanks Ranman256, I'm still working out the concatentation rules. VehicleID is a text variable in the DLookup based on another field in the query. So I incorporated your suggestion to make: PreviousMileage: DLookUp("[Mileage]","VehicleGasMileageQ","[ServiceID]=" & [ServiceID]-1 & " and...

Hello, I have a query designed to calculate gas mileage for multiple vehicles. I am working on a DLookup statement in a query to return the previous mileage value for the same vehicle in order to calculate fuel efficiency. The following statement works to return the previous mileage value...

That works perfectly! I think I get confused with the "&"s and the "And" part of the DCount statement. Thanks so much! Now our program volunteers will be able to easily receive percentile rank's for their stream. Matt

Hello, I have a database used to manage volunteer water quality data. For example, I have a table with 20 years of water quality data. An example water quality record has [FieldDate] and [WaterQualityValue]. I would like to run a query that calculates the the number of records that are less...

Hello everyone, my name is Matt and I have been working with Access for about a year to manage a citizen science program called Illinois RiverWatch. Thanks for everyone's input on this forum, it really helps me find my away around since I do not have a programming background.