IF isnull want query to answere 1 (1 Viewer)

[mkelly]

I have a query and it can be a null value if it is null I want it to return 1 if not null I want the calculation. This is what I have but it will not work.

Please help!!!
repo on sitePercent of copy jobs not rejected:IIF([Rejected Job Percentage]=0,1,(1-[Rejected Job Percentage])

 

[allan57]

try the following:-

IIf(nz([Rejected Job Percentage])=0,1,1-[Rejected Job Percentage])

 

[Brianwarnock]

Why not use IsNull?

IIf(IsNull([Rejected Job Percentage]),1,1-[Rejected Job Percentage])

Brian

 

[FoFa]

Can't you use NZ([Rejected Job Percentage],1)