IIF function in a report

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

Am familiar with If together with the And function in
Excel for having two criteria be true to determine an
outcome. Can I do the same thing in Access?
 
Am familiar with If together with the And function in
Excel for having two criteria be true to determine an
outcome. Can I do the same thing in Access?
Click to expand...

Sue,
Yes, but how is determined by where.
In VBA event you could use either If .. Then .. Else or IIF().

If [Lastname] = "Smith" and [FirstName] = "John" then
' Do this
Else
' Do that
End if

or...
in VBA or as a Control's Control Source expression:
=IIf([LastName] = "Smith" and [FirstName] = "John,Do True Part,Do
False Part)

In a Query..
Exp:IIf([LastName] = "Smith" and [FirstName] = "John,Do True Part,Do
False Part)
 
Jan,
You missed the quote after John:
=IIf([LastName] = "Smith" and [FirstName] = "John", Do True Part, Do False
Part)


--
Duane Hookom
MS Access MVP


Jan said:
Am familiar with If together with the And function in
Excel for having two criteria be true to determine an
outcome. Can I do the same thing in Access?
Click to expand...

Sue,
Yes, but how is determined by where.
In VBA event you could use either If .. Then .. Else or IIF().

If [Lastname] = "Smith" and [FirstName] = "John" then
' Do this
Else
' Do that
End if

or...
in VBA or as a Control's Control Source expression:
=IIf([LastName] = "Smith" and [FirstName] = "John,Do True Part,Do
False Part)

In a Query..
Exp:IIf([LastName] = "Smith" and [FirstName] = "John,Do True Part,Do
False Part)
Click to expand...
 
Jan,
You missed the quote after John:
=IIf([LastName] = "Smith" and [FirstName] = "John", Do True Part, Do False
Part)
Click to expand...

Thanks, Duanne,
Actually Jan didn't miss it, I did. I inadvertently used her identity
to post. I hope she doesn't start getting spam now.
 
Back
Top