"If / Then" Statements

[Dawn]

Is there a way to do an "If/Then" type statement like you
can in Excel?

 

[Les]

You can use IIF statement in a query. If you want to get
more involved in coding, there is an If/else statement
available.

Check online help for more details.

 

[Andy]

Dawn;

Here is a start:

IIF([Field1]>0,[Field2],"Less than Zero")

Andy