If then statement in Access

[Reggie2004]

Is there a such thing as an If then statement in Access? If so what is the format/

Reg

 

[Golom]

Access" is really VB (but with some of its own custom functions like DoCmd) so the "Access" If ... Then construct is the same as VB

If <Condition> Then
   ' Do something when <Condition> is TRUE
Else
   ' Do something else when <Condition> is FALSE
End If

There's also the Immediate IF

IIF ( <Condition>, True Part, False Part )

 

[Reggie2004]

So basically I could just open a query and just insert my code. I am an old programmer from the 80's. I have noticed a lot of similarities. What I want to do on the next half of my project is this...

If final.[SSP] is not null then
final.[filing status] = 3
Else
final.[filing status] = 1
End If

 

[Golom]

That's right ... except that in code you need to use the IsNull function. "IS NOT NULL" is SQL syntax.

If NOT IsNull(final.[SSP]) Then
   final.[filing status] = 3
Else 
    final.[filing status] = 1
End If