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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CASE Statements
- Thread starter Scooby62
- Start date
This time ok but please do some searching on your own next time. Now is you have a problem with a case in a query we're all for lending a hand 
[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]
[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]
- Thread starter
- #3
Hey there.
I do appreciate your help but I'm creating a new field in an SQL query called EligDt (eligibility date). Basically if a person is of one status or another I want the case statement to alter their hire date. I'm working with more than one status, hence the need for a nested CASE statement.
I do appreciate your help but I'm creating a new field in an SQL query called EligDt (eligibility date). Basically if a person is of one status or another I want the case statement to alter their hire date. I'm working with more than one status, hence the need for a nested CASE statement.
Hi Scooby - I was searching for some assistance with this too, and found the following thread with the first reply being a very helpful one from AlexCuse:
Mark, HH Associates
Mark, HH Associates
- Status
Similar threads
- Locked
- Question
