|
| 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 27th, 2008, 05:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
#Error is returned on sum([FieldName])
I'm trying to get rid of the #Error on a sum field in an Access report. I've
tried =Sum(IIf(IsNull([CostDiff]),0,[CostDiff])) and the nz function to no avail. It looks like to me like the reason that it is doing it is because the quey is not returning any records. The query is right, there are no records to return. I need the report to show 0 instead of #Error in this instance. Any help is appreciated. 
|
|
#2
October 27th, 2008, 05:55 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#Error is returned on sum([FieldName])
Try:
=IIf([HasData] = -1, Sum([CostDiff]),0) -- Duane Hookom Microsoft Access MVP "beh" wrote: I'm trying to get rid of the #Error on a sum field in an Access report. I've tried =Sum(IIf(IsNull([CostDiff]),0,[CostDiff])) and the nz function to no avail. It looks like to me like the reason that it is doing it is because the quey is not returning any records. The query is right, there are no records to return. I need the report to show 0 instead of #Error in this instance. Any help is appreciated.
|
|
#3
October 27th, 2008, 06:08 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#Error is returned on sum([FieldName])
beh wrote:
I'm trying to get rid of the #Error on a sum field in an Access report. I've tried =Sum(IIf(IsNull([CostDiff]),0,[CostDiff])) and the nz function to no avail. It looks like to me like the reason that it is doing it is because the quey is not returning any records. The query is right, there are no records to return. I need the report to show 0 instead of #Error in this instance. It seems to me that a report with no records is not going to be very useful ;-) Maybe your report is more complex than you have stated in your question? If the Sum is in a subreport, then you should read up on the HasData property in VBA Help and provide more details in a follow up question. -- Marsh MVP [MS Access]
|
|
#4
October 27th, 2008, 06:18 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#Error is returned on sum([FieldName])
Thank you. That worked. I've never seen the hasdata before.
"Duane Hookom" wrote: Try: =IIf([HasData] = -1, Sum([CostDiff]),0) -- Duane Hookom Microsoft Access MVP "beh" wrote: I'm trying to get rid of the #Error on a sum field in an Access report. I've tried =Sum(IIf(IsNull([CostDiff]),0,[CostDiff])) and the nz function to no avail. It looks like to me like the reason that it is doing it is because the quey is not returning any records. The query is right, there are no records to return. I need the report to show 0 instead of #Error in this instance. Any help is appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
