IiF in Query

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
 
G

Gina Whipp

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
 
J

Jerry Whittle

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.
 
Top