|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 17th, 2007, 08:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Convert Negative values to zero
I am calculating downtime in query. Of course, when you have a
negative value is not considered downtime and I want to be able to convert all negative numbers to Zero. Please help me out Thank you 
|
|
#2
July 18th, 2007, 08:50 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Convert Negative values to zero
I thought an update query would be appropriate (update to zero when the criteria is less than zero) or you may be able to use the afterupdate event in the form. "Majic" wrote: I am calculating downtime in query. Of course, when you have a negative value is not considered downtime and I want to be able to convert all negative numbers to Zero. Please help me out Thank you
|
|
#3
July 20th, 2007, 07:31 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Convert Negative values to zero
On Jul 18, 3:50 am, scubadiver
wrote: I thought an update query would be appropriate (update to zero when the criteria is less than zero) or you may be able to use the afterupdate event in the form. "Majic" wrote: I am calculating downtime in query. Of course, when you have a negative value is not considered downtime and I want to be able to convert all negative numbers to Zero. Please help me out Thank you- Hide quoted text - - Show quoted text - Thank you
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
