If Then Else Statements in Access '97

[Trey]

Hi --

Where and how would I build an If-Then-Else statement in Access '97?

Thanks so much!

 

[fredg]

Hi --

Where and how would I build an If-Then-Else statement in Access '97?

Thanks so much!

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.