IIF(and) statement

[Pete Provencher]

Access 2000

Trying to look at two variables in my IIF statement;

IIF(and([horry county].[propertystatus]<>"on market",[horry
county].[acres] is null),[hc acreage].[acreage],[horry county].[acres])

I need it to look at if propertystatus <> "on market" and acres is null to
then update by whether it is true or false.

Any help will be appreciated.


Pete Provencher

 

[Fredg]

Try:

Exp:IIf([PropertyStatus]<>"on market" AND IsNull([Acres]), True part here,
False Part here)

 

[Pete Provencher]

Thanks alot. It worked. Can't seem to remember these formulas but this and
other news groups are a great benefit to everyone. Sure appreciate those
that know taking the time to help us that need it.

Pete Provencher

Try:

Exp:IIf([PropertyStatus]<>"on market" AND IsNull([Acres]), True part here,
False Part here)
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Access 2000

Trying to look at two variables in my IIF statement;

IIF(and([horry county].[propertystatus]<>"on market",[horry
county].[acres] is null),[hc acreage].[acreage],[horry county].[acres])

I need it to look at if propertystatus <> "on market" and acres is null to
then update by whether it is true or false.

Any help will be appreciated.


Pete Provencher