Gossamer Forum
Home : General : Databases and SQL :

Sql If Statement

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.
Quote Reply
Re: [jacq] Sql If Statement In reply to
What programming language/script/application are you using to output the results?

ASP, Cold Fusion, Perl, etc.?
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Stealth] Sql If Statement In reply to
Hi Stealth
I am doing my program in Microsoft Access 2002. I would presume the output would be in Microsoft Basic?? in Microsoft Access itself. I can put the script in as a SQL statement in a query, does that help?
Jacq