Search results

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...

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.