 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2006Convert Negative Numbers to Zero?
Hi, I have a query with an expression field that calculates the number of days late by subtracting the due date from the completion date. This of course means that if a task was completed on-time, the number will be negative. Since I want to display both late and on-time tasks, is there a way to display negative numbers as '0'? Thanks! Xavier IIF([YourSubtraction]<0, 0,[YourSubtraction]) OR IIF([YourSubtraction]<0, "On-time",[YourSubtraction]) > Hi, I have a query with an expression field that calculates the number > of days late by subtracting the due date from the completion date. [quoted text clipped - 3 lines] > > Xavier |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.