Where to put"nz" in a formula in an Access query?

[Teresa Barnacle]

Need help again,sorry

B: IIf([Miles]>150,130*3.8,II f([Miles]>19.9 And [Miles]<150.1,([Miles]-20)*3.8))

How do I put in this "if null put me a 0 in" ?

My other sums don't work if I don't put a zero in, sometimes I could scream !

Regards, Teresa

[TheSmileyCoder]

I don't mean to sound rude but have you tried the helpfile on the nz function?

Anyways since [Miles]is the only thing that can be null, thats the part you want to check for. So around the [Miles] you could put:

Nz([Miles],0)

[Teresa Barnacle]

Thanks I will give it a go.

I did try the Microsoft help file with nz, but the explanation went way over my head !

[Teresa Barnacle]

No, couldn't get that to work.

If it was a simply Nz([Miles], 0) I could do, but there are to many ( [ for me to work out where the nz's go !

Help !

[NeoPa]

Teresa, this is good thinking, but on balance for this formula I'd go with ADezii's idea of using IsNull() just the once, rather than Nz() three times. You'll find the proposed solutions in the other thread - Excel Formula into an Access Query.