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 statement 2

Status
Not open for further replies.
Mr2006

Mr2006

Technical User
Joined
Jun 21, 2006
Messages
80
Location
US
Hello

I have a calculation formula in a field, [workdays]-[offdays]-1. the result sometime shows negative number. I want to include in the formula if the total is negative, the result will be zero.

Any Suggestions!!
 
Sort by date Sort by votes
the function is:
Code: 
iif(logical comparison, value if true, value if false)

iif([workdays]-[offdays]-1<0, 0, [workdays]-[offdays]-1)

Leslie

Have you met Hardy Heron?
 
Upvote 0 Downvote
There are times when you need to convert an expression back to numeric. This may be one of them. Taking Leslie's solution you may need to use
Code: 
Val(iif([workdays]-[offdays]-1<0, 0, [workdays]-[offdays]-1))

Duane
Hook'D on Access
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question Question
Jet Sql Statement - Select Distinct Multiple Columns
Replies
4
Views
1K
Swi
Swi
serino
  • Locked
  • Question Question
Help with SQL inner join statement
Replies
2
Views
610
serino
serino
cimoli
  • Locked
  • Question Question
Access Query IIF statement with multiple conditions
Replies
6
Views
1K
cimoli
cimoli
supportsvc
  • Locked
  • Question Question
Query to Display $0 if no record in Quarter with YTD total
Replies
14
Views
1K
supportsvc
supportsvc
timidjewel
  • Locked
  • Question Question
If Statement
Replies
10
Views
519
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top