|
| 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
October 20th, 2004, 08:59 PM
|
|||
|
|||
#ERROR in calculated field
hi,
I have the following expression in a field: ACP: Format([Ext]/[QOH],"0.00000") works fine but as you know if try to divide 0/0 will get the #ERROR. Is there a way to go around this and put a 0 instead? I try putting Nz, but not sure if this works or maybe I put it wrong. Please advise with any feedback. Thanks, Juan 
|
|
#2
October 20th, 2004, 09:43 PM
|
|||
|
|||
|
ACP: Format(IIf(QOH=0,0, [Ext]/[QOH]),"0.00000")
-- Duane Hookom MS Access MVP -- "juan" wrote in message ... hi, I have the following expression in a field: ACP: Format([Ext]/[QOH],"0.00000") works fine but as you know if try to divide 0/0 will get the #ERROR. Is there a way to go around this and put a 0 instead? I try putting Nz, but not sure if this works or maybe I put it wrong. Please advise with any feedback. Thanks, Juan
|
|
#3
October 20th, 2004, 10:35 PM
|
|||
|
|||
|
Hello Duane,
thanks alot for your help. Seems to be working. I really appreciate the help. Have a good one. Thanks again, juan -----Original Message----- ACP: Format(IIf(QOH=0,0, [Ext]/[QOH]),"0.00000") -- Duane Hookom MS Access MVP -- "juan" wrote in message ... hi, I have the following expression in a field: ACP: Format([Ext]/[QOH],"0.00000") works fine but as you know if try to divide 0/0 will get the #ERROR. Is there a way to go around this and put a 0 instead? I try putting Nz, but not sure if this works or maybe I put it wrong. Please advise with any feedback. Thanks, Juan .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Display two different strings in Calculated Field based on rhe value in another field | Adrian | General Discussion | 1 | August 8th, 2004 08:42 PM |
| Calculated Field Problem: Picking a date based on value in another field | Dkline | Database Design | 3 | June 23rd, 2004 04:05 PM |
| Calculated field | D | Running & Setting Up Queries | 5 | June 17th, 2004 10:11 PM |
| NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Linear Mode
