Hi -- Where and how would I build an If-Then-Else statement in Access '97? Thanks so much!
T Trey Aug 24, 2005 #1 Hi -- Where and how would I build an If-Then-Else statement in Access '97? Thanks so much!
F fredg Aug 24, 2005 #2 Hi -- Where and how would I build an If-Then-Else statement in Access '97? Thanks so much! Click to expand... If .. then ..Else is a VBA statement, so you would place it in a Module or in a form or report code. If you wanted something similar for use directly in an Access query or in a form/report control source, you could use an IIf() function. Look up IIF in VBA help, then click on the See Also link for more on If .. then .. else.
Hi -- Where and how would I build an If-Then-Else statement in Access '97? Thanks so much! Click to expand... If .. then ..Else is a VBA statement, so you would place it in a Module or in a form or report code. If you wanted something similar for use directly in an Access query or in a form/report control source, you could use an IIf() function. Look up IIF in VBA help, then click on the See Also link for more on If .. then .. else.
