Parameter is divided into two parts, the Test and the Result if True. The test comes prior to the keyword of Then and the Result if True comes after.

Description:

The first part of the Test must be a field name in the current scope, a string literal without any spaces, or a number. The next item after a space must be a valid comparison. The final item after another space may be a field name in the current scope, a string literal, a number, or an expression in parentheses. The Result may be either a field name, a string literal, or an expression.

If a boolean True/False is desired to be assigned to the Field, then only state the Test and do not use the Then keyword or a Result. If the Test evaluates to True it will be set to the single character of "y" otherwise it will be cleared.

List of Math & Text Comparison Operations: Here

Example:

- Using [If] as an DB Attribute (Destination is implied by the selected Field)

[If] Firstname = "Bill" THEN "William"

[If] Firstname = ("Bi" & "ll") THEN "William"

[If] Lastname = Firstname THEN Fullname

[If] Lastname = Firstname

- Using [If] as a Top Query assignment operator (Destination must be declared explicitly)

Email [If] Email = "" Then ContactEmail
Email [If] Email = "" Then MemTab.Person.Email