Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by TeaBeen
-
Querry calculation If syntax.... causing brain ache
Thanks :) For anyone who might find this and need it i used IIf([Type] Is Null And [Score]=0,"Pass","Fail")- TeaBeen
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Querry calculation If syntax.... causing brain ache
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...- TeaBeen
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
