error in a sumcontrol when null in subreport

[Guest]

Hi

I have Access 2003 and a report with subreports.
I have have a sum control (Currency) where I get error when it is null in
the subreport mentioned.

I guess I need a nz here but cannot figure out how to bracket it correct

=ResultReportSub.Report![Sum of Price]

Thanks in advance

 

[Guest]

In the [Sum of Price] field in the subform, I assume you have

=Sum([Price]) with the price field name or other name, change it to

=Sum(nz([Price],0))

 

[Guest]

Hi

First it did not accept , so changed it to ; and not it looks like this:
=Sum(nz([NettoprisSEK1];0))

But still receive the same error when null in the subreport

What can be wrong

Mattias

In the [Sum of Price] field in the subform, I assume you have

=Sum([Price]) with the price field name or other name, change it to

=Sum(nz([Price],0))
--
I hope that helped
Good luck

Hi

I have Access 2003 and a report with subreports.
I have have a sum control (Currency) where I get error when it is null in
the subreport mentioned.

I guess I need a nz here but cannot figure out how to bracket it correct

=ResultReportSub.Report![Sum of Price]

Thanks in advance

 

[Duane Hookom]

Is the subreport empty (returns no rows) or are there null values? If the
subreport doesn't return any rows use:

=IIf(ResultReportSub.Report.HasData, ResultReportSub.Report![Sum of Price],
0)

--
Duane Hookom
MS Access MVP

Hi

First it did not accept , so changed it to ; and not it looks like this:
=Sum(nz([NettoprisSEK1];0))

But still receive the same error when null in the subreport

What can be wrong

Mattias

In the [Sum of Price] field in the subform, I assume you have

=Sum([Price]) with the price field name or other name, change it to

=Sum(nz([Price],0))
--
I hope that helped
Good luck

Hi

I have Access 2003 and a report with subreports.
I have have a sum control (Currency) where I get error when it is null
in
the subreport mentioned.

I guess I need a nz here but cannot figure out how to bracket it
correct

=ResultReportSub.Report![Sum of Price]

Thanks in advance

 

[Guest]

Hi

The IIf made the error dissapere.

Thanks!

Mattias

Is the subreport empty (returns no rows) or are there null values? If the
subreport doesn't return any rows use:

=IIf(ResultReportSub.Report.HasData, ResultReportSub.Report![Sum of Price],
0)

--
Duane Hookom
MS Access MVP

Hi

First it did not accept , so changed it to ; and not it looks like this:
=Sum(nz([NettoprisSEK1];0))

But still receive the same error when null in the subreport

What can be wrong

Mattias

In the [Sum of Price] field in the subform, I assume you have

=Sum([Price]) with the price field name or other name, change it to

=Sum(nz([Price],0))
--
I hope that helped
Good luck


:

Hi

I have Access 2003 and a report with subreports.
I have have a sum control (Currency) where I get error when it is null
in
the subreport mentioned.

I guess I need a nz here but cannot figure out how to bracket it
correct

=ResultReportSub.Report![Sum of Price]

Thanks in advance