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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simulating Decode function

Status
Not open for further replies.
sentil

sentil

Programmer
Apr 18, 2001
6
Hi, I need to simulate the decode function of Oracle in Access. Is there an equivalent command in Access for Decode?

Thanks for any help,
Senthil

 
Sort by date Sort by votes
Switch() is a function and is close but if you can use statements (in other words anywhere you aren't limited to an expression) the closest is Select Case. I started out with nothing, and I still have most of it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JackSapsford
  • Locked
  • Question
Microsoft Access 2000 - Function Is Not Available...
Replies
12
Views
372
combo
combo
bobjackson
  • Locked
  • Question
Count function
Replies
2
Views
114
dhookom
dhookom
Moss100
  • Locked
  • Question
Writing a function loop through a settings table and set TempVars 2
Replies
9
Views
153
Andrzejek
Andrzejek
bdmoran
  • Locked
  • Question
Access function to round time to quarter hour
2
Replies
28
Views
385
MajP
MajP
jahnell
  • Locked
  • Question
mde and accde of database will not function
Replies
1
Views
101
jahnell
jahnell

Part and Inventory Search

Sponsor

Back
Top