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
|
|||
|
|||
#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
|
|||
|
|||
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
|
|||
|
|||
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 |