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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if and decode statement? what can I use?

Status
Not open for further replies.
alh1002

alh1002

Technical User
Joined
Mar 27, 2006
Messages
41
Location
US
the excel equivalent of what I want
if(a<b,a-b,0)

how can i have that in sql (access) I am use to oracle where I can use decode but that doesn't work in access
 
Sort by date Sort by votes
You wanted this ?
IIf(a<b,a-b,0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Submeg
  • Locked
  • Question Question
Selecting shapes based on its name and then arranging them in a circle
Replies
2
Views
462
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question Question
Copy data between SQL and Oracle
Replies
8
Views
2K
remeng
remeng
remeng
  • Locked
  • Question Question
If obsolete - deactivate all but one macro
Replies
6
Views
834
mintjulep
M
JAB_123
  • Locked
  • Question Question
I want to use an excel file for inp
Replies
3
Views
737
dhookom
dhookom
dgillz
  • Locked
  • Question Question
Back coloring an entire row if a duplicate is found in a dynamic range
Replies
18
Views
1K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top