If Statement

Hi Jonathan. There are a number of ways to achieve this. You could use nested IF statements, or concatenate AND statements but this can get difficult to follow and debug. Alternatively, you could set the value of a new reference variable dependent on each IF statement as so:

If DateVariable <= #3/31/2009# And AgentID <> 355 Then
scenario1 = TRUE

Once set you can use the scenario1 variable in further IF statements:

If scenario1 = TRUE AND AgentID <>356 Then
cost = CCur(Doc * 19.45)

...and so on! You could also use the CASE statement to make the code more explicit.

Hope this helps,

Anthony