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 strongm 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
Jun 21, 2006
80
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
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
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
285
Swi
Swi
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
136
serino
serino
cimoli
  • Locked
  • Question
Access Query IIF statement with multiple conditions 3
Replies
6
Views
350
cimoli
cimoli
supportsvc
  • Locked
  • Question
Query to Display $0 if no record in Quarter with YTD total
Replies
14
Views
219
supportsvc
supportsvc
timidjewel
  • Locked
  • Question
If Statement 2
Replies
10
Views
110
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top