Can anyone instruct me as to develop a if, then, else statement for a facility that I inspect that would give the following, If {View_tblInspections.InspectionDate}= Month({View_tblInspections.InspectionDate}) in 10 to 12 and year ({View_tblInspections.InspectionDate}) = 2007 then insert that date {View_tblInspections.InspectionDate} else insert nodate
I need the order for the statement to work. any ideas?? Ron

THanks,