Record Selection

[Shannon2008]

I am trying to select records based on the following formula:

IF {COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="AB" THEN
IF{COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<10.00 THEN
IF {COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="NS" THEN
{COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<9.00

The formula does not contain any errors, however it is not returning any records, but I know they exist. I think I am missing a step.


Any help is greatly appreciated.
Thanks.
SL

 

[kskid]

You probably need this
(
(
{COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="AB" and
{COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<10.00
)
or
(
{COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="NS" AND
{COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<9.00
)
)

 

[Shannon2008]

Thank you. That was easy!