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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: robertthomas
- Content: Threads
- Order by date
-
Need Help with IIF Statement Inside Access Query
Ok, here's my problem. I want to look at 2 columns, COL1 and COL2. If either of them have number 3 or greater, then I would like my new COL3 to display "Level 2". If COL1 and COL2 are less than 3 but greater than 0, then COL3 should say, "Level 1". If COL1 and COL2 say 0, then it should display...- robertthomas
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
