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 Chriss Miller 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
Mar 27, 2006
41
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

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
581
mintjulep
M
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
519
dhookom
dhookom
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
912
SkipVought
S
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate

Part and Inventory Search

Sponsor

Back
Top