I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the most recent oil change. I've tried using an IIF calculation but it only pulls the most recent ending mileage and not just the ending mileage where the purpose equals oil change. Can someone help? Thanks.
March 11, 2011 2:45 PM
March 11, 2011 2:52 PM