Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Sql If Statement

Mar 7, 2004, 2:16 AM
jacq
New User (3 posts)
Mar 7, 2004, 2:16 AM
Views: 6687
Shortcut
Quote Reply
Sql If Statement
I am new to Access 2002 and using SQL and would like to know where I put the If statement. I have the query getting the info, but I would like an If statement that does the following for a "new expression" in my query:
If [score] = 36 [new handicap] = [handicap]
If [score] > 36 [new handicap] = [handicap]+1
If [score] < 36 [new handicap] = [handicap] - (36 - [score])
Any ideas please.
It is going to be for a program for a golf shop.
Subject Author Views Date
Thread Sql If Statement jacq 6687 Mar 7, 2004, 2:16 AM
Thread Re: [jacq] Sql If Statement 		Stealth 6473 Mar 7, 2004, 9:55 PM
Post Re: [Stealth] Sql If Statement 		jacq 6393 Mar 7, 2004, 11:54 PM