IiF in Query

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

What's wrong with my below statement

Apryr2: IIf([tbl-sks].[aprdt] Is
Null,Format([tbl-sks].[fstrlsedt],"yyyy",Format([tbl-sks].[aprdt],"yyyy")))


Thanks
 
zyus,

Not really sure as you failed to mention what error message you are getting.
I did see one paranthesis out of place (See below, watch for word wrap,
should be all on one line). However, if that does not fix your issue then
please port what message and/or results you are getting and what you expect
to happen.

Apryr2: IIf([tbl-sks].[aprdt] Is
Null,Format([tbl-sks].[fstrlsedt],"yyyy"),Format([tbl-sks].[aprdt],"yyyy"))

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Apryr2: IIf(IsNull([tbl-sks].[aprdt]) = True,
Format([tbl-sks].[fstrlsedt],"yyyy"), Format([tbl-sks].[aprdt],"yyyy"))

Looks like you have an ) out of place.
 
Back
Top