IIF(and) statement

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

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
 
Try:

Exp:IIf([PropertyStatus]<>"on market" AND IsNull([Acres]), True part here,
False Part here)
 
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
Fredg said:
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.


Pete Provencher said:
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
Click to expand...
Click to expand...
 
Back
Top