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.
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.