IIF statement

I have created the following iff statement to key off of
a text box on a separate form, but it is not working,
what am I doing wrong?

=IIf([Forms]![Query Control Form]![STATE]
="AB","Alabama","Other Region")

I am being told that the expression I entered may contain
invalid syntax. Can you help me?

Desmond

Nothing jumped out at me. What happens if you rename the form and control,
and rebuild the query? Sometimes Access gets "confused"...

--
Good luck

Jeff Boyce
Access MVP

This may have been already answered. I have a table that consists of 30
fields. These fields have dates as column headings. The other column(s)
have a customer field, and a check box indicating if a payment is promised.

In a query, I would like to only see those customers with a check in the
check box and only those fields that have no nulls.

For example, company A has promised to pay $100 on 06/01/05 and company B
has promised to pay $1000 on 06/03/05.

Is it possible to show only these two fields and not show the remaining
fields?

Sorry iif this is long. Any help is greatly appreciated.

Yes, just filter them out in your query. Use TRUE/FALSE condition for
checkbox and IS NULL/IS NOT NULL for nulls in your WHERE clause.

"shooter" wrote:

This may have been already answered. I have a table that consists of 30
fields. These fields have dates as column headings. The other column(s)
have a customer field, and a check box indicating if a payment is promised.

In a query, I would like to only see those customers with a check in the
check box and only those fields that have no nulls.

For example, company A has promised to pay $100 on 06/01/05 and company B
has promised to pay $1000 on 06/03/05.

Is it possible to show only these two fields and not show the remaining
fields?

Sorry iif this is long. Any help is greatly appreciated.