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 and Zero Value Help
I have a query with the following equation AVG Hold Time: [Total Hold
Time]/[Total ACD]. Some fields show #error or a zero value (0:00:00). On a report footer I would like to average the AVG Hold Time by month or even better take the sum of Total ACD and the sum of Total Hold Time on the report and divide those. Either way I keep getting an Overflow error. Also, in the query I tried Is Not Null criteria for AVG Hold Time, but get an overflow error. |
#2
|
|||
|
|||
#Error and Zero Value Help
For a single record (detail section) you would normally use:
=IIf(Nz([Total ACD],0) =0, Null, [Total Hold Time]/[Total ACD]) In a group/report header or footer =IIf(Nz(Sum([Total ACD]),0) =0, Null, Sum([Total Hold Time])/Sum([Total ACD])) -- Duane Hookom Microsoft Access MVP "Whitney" wrote: I have a query with the following equation AVG Hold Time: [Total Hold Time]/[Total ACD]. Some fields show #error or a zero value (0:00:00). On a report footer I would like to average the AVG Hold Time by month or even better take the sum of Total ACD and the sum of Total Hold Time on the report and divide those. Either way I keep getting an Overflow error. Also, in the query I tried Is Not Null criteria for AVG Hold Time, but get an overflow error. |
Thread Tools | |
Display Modes | |
|
|