Search results

I think so? it's looking up certexpires from qry_personcert which returns certname, certtype, certnum and certexpires with [Forms]![frm_Person]![cbo_Name]as the criteria for certname. I figured that by using the query first it'd simplify the code for the DMax rather than adding criteria?

Thanks, I'm no expert in access, but i just can't see why it's taken the expression and reduced it to if coursedate>certexpires then coursedate+36months if coursedate<certexpires then coursedate+39months

No change :-/

[SOLVED] Nested IIf( with DMax and DateAdd not working correctly As the control source of txt_expdate I have the following =IIf(([txt_coursedate]>DMax("certexpires","qry_personcert")), DateAdd("m",36,[txt_coursedate]), IIf(([txt_coursedate] Between DMax("certexpires","qry_personcert") And...