Printable View
Need to create a query that when a specified mileage interval is reached (5000 for gas and 7500 for diesel) then that record is displayed. Their are fields for both the current mileage and type of engine (gas, diesel). Any help is greatly appreciated.
ocranger23,Quote:
Originally Posted by ocranger23
Without more details about your table structures, it will be very difficult to give you anything
How do you determine the mileage intervals.
Here is an example that may help:
Referring to a Field in the Previous or Next Record
Scroll down to to find:
It may not be exactly what you want, but it hopefully is close enough that you can modify it to meet your needsQuote:
The following example demonstrates how to use the PrevRecVal() function in a form to create a mileage log. The custom function returns the previous odometer reading, which is used to calculate miles per gallon (MPG) for an automobile.
Hi,
It depends how the mileage interval is added and what you mean by record is displayed. Do you mean a record on a subform or a seperate form??Quote:
Need to create a query that when a specified mileage interval is reached (5000 for gas and 7500 for diesel) then that record is displayed
Either way you could do something like this:
if me!enginetype = "gas" and me!mileage = 5000 then
record is displayed code e.g. form.open
elseif me!enginetype = "diesel" and me!mileage = 7500 then
record is displayed code e.g. form.open
end if
You would still need to display the record if the mileage interval is greater than 5000 for gas and 7500 for diesel. Most mileage intervals will not be exactly 5000 or 7500.