Access 2003 IIF Function?
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 11, 2011 2:45 PM
UPDATED:
March 11, 2011 2:52 PM
RELATED QUESTIONS
- How can I ensure that the invoice data goes to the correct record on the subform datasheet?
- Access Tab Control Problem
- Copy tab that upload based on computed subform
- How to pass a Whereclause from a form to another form's subform in Access 2000?
- Using combo box to populate a sub form which is used to create a new record
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
