Creating a nested IF function for a query

[Rudi]

Hi,

I need some advice on creating a nested IF function for an Access query. My example is in an Excel spreadsheet which I have attached. I am on the right track with the formula, but I'd like to bounce it off the Access gurus to ensure I am not going the looooong way around.

All the details are in the attachment.

TIA for any help/advice!

[HansV]

AND(...) is an Excel function, not an Access function. The Access equivalent of "AND(P,Q)" is "P And Q" (don't copy the quotes).

You could use =IIf([Field1]>=80 And [Field2]>=80 And ..., ...) or =IIf(([Field1]>=80)*([Field2]>=80)*..., ...)

But I don't think there's a really short version - you do need to check all the conditions.

[Rudi]

Thanks for that advice and correction Hans. I appreciate it.