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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Null 1
iif Expression Error 5
To Include Count In Crosstab Query 1
To Add % In Query 6
Calculation In Query 1
Invalid Argument In Make Table Query 2
Group by Years 5
Sort in Query 3

Top