Querry calculation If syntax.... causing brain ache

[TeaBeen]

Hi!
Calculations newbie here!!

i have a main table (tblMain) and sub table (tblNonCon)referenced in a querry. I'm trying to generate a Pass/Fail field. I need something along the lines of

If tblmain.support ledge not "acceptable" or tblNonCon.countoftype > 0 then fail,
else
Pass

I've tryed a few variations but can't get it to work

 

[PHV]

Take a look at the IIf function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TeaBeen]

Thanks

For anyone who might find this and need it i used

IIf([Type] Is Null And [Score]=0,"Pass","Fail")