Subreport - No record creates #Error

[Cuda]

Here's my simple code which works fine as long as there's records.

=[Change Orders subreport1].[Report]![Sum CO Amount]
this calculates the total perfectly as long as there's
a record

I've tried the following codes
=IIF([Change Orders
subreport1].[Report]![RecordsetClone].[RecordCount]>0,[Change Orders
subreport1].[Report]![Sum CO Amount],0)
this gives me the #Name? error so I must have a typo.

=IIF([Change Orders subreport1].[Report]![Sum CO Amount]HasData, [Change
Orders subreport1].[Report]![Sum CO Amount],0)
invalid syntax

 

[Ken Snell MVP]

This is example of the expression that I use in such situations:

=IIf([srptBegBal].[Report].[HasData]=True,[srptBegBal].[Report]![BegBal],0)

so for you, try this:


=IIf([Change Orders subreport1].[Report].[HasData]=True,[Change Orders
subreport1].[Report]![Sum CO Amount],0)

 

[Ken Snell MVP]

This is example of the expression that I use in such situations:

=IIf([srptBegBal].[Report].[HasData]=True,[srptBegBal].[Report]![BegBal],0)

so for you, try this:


=IIf([Change Orders subreport1].[Report].[HasData]=True,[Change Orders
subreport1].[Report]![Sum CO Amount],0)

 

[Cuda]

Thanks! That did the trick. I had to re-enter the brackets around HasData
twice before they actually stayed, but now it's working like a charm.

This is example of the expression that I use in such situations:

=IIf([srptBegBal].[Report].[HasData]=True,[srptBegBal].[Report]![BegBal],0)

so for you, try this:


=IIf([Change Orders subreport1].[Report].[HasData]=True,[Change Orders
subreport1].[Report]![Sum CO Amount],0)

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Here's my simple code which works fine as long as there's records.

=[Change Orders subreport1].[Report]![Sum CO Amount]
this calculates the total perfectly as long as
there's
a record

I've tried the following codes
=IIF([Change Orders
subreport1].[Report]![RecordsetClone].[RecordCount]>0,[Change Orders
subreport1].[Report]![Sum CO Amount],0)
this gives me the #Name? error so I must have a
typo.

=IIF([Change Orders subreport1].[Report]![Sum CO Amount]HasData, [Change
Orders subreport1].[Report]![Sum CO Amount],0)
invalid syntax

 

[Cuda]

Thanks! That did the trick. I had to re-enter the brackets around HasData
twice before they actually stayed, but now it's working like a charm.

This is example of the expression that I use in such situations:

=IIf([srptBegBal].[Report].[HasData]=True,[srptBegBal].[Report]![BegBal],0)

so for you, try this:


=IIf([Change Orders subreport1].[Report].[HasData]=True,[Change Orders
subreport1].[Report]![Sum CO Amount],0)

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Here's my simple code which works fine as long as there's records.

=[Change Orders subreport1].[Report]![Sum CO Amount]
this calculates the total perfectly as long as
there's
a record

I've tried the following codes
=IIF([Change Orders
subreport1].[Report]![RecordsetClone].[RecordCount]>0,[Change Orders
subreport1].[Report]![Sum CO Amount],0)
this gives me the #Name? error so I must have a
typo.

=IIF([Change Orders subreport1].[Report]![Sum CO Amount]HasData, [Change
Orders subreport1].[Report]![Sum CO Amount],0)
invalid syntax