K
keung
I have a grouped report from a query which contains a formula to add and
subtract totals from subreports within this report. Some of the
subreports for certain groupings have no data associated with them, so
the subreport data does not appear in the report.
The problem I have is that the report displays '#Error' for all of
these formulas because the data for these fields do not exist in the
tables.
I know that the reason for this is because I am trying to use values
that do not exist in my tables, but is there any way that I can ignore
these missing values?
Note: These values are neither null or zero-length strings, they do
not exist at all in the database.
Any help is greatly appreciated
subtract totals from subreports within this report. Some of the
subreports for certain groupings have no data associated with them, so
the subreport data does not appear in the report.
The problem I have is that the report displays '#Error' for all of
these formulas because the data for these fields do not exist in the
tables.
I know that the reason for this is because I am trying to use values
that do not exist in my tables, but is there any way that I can ignore
these missing values?
Note: These values are neither null or zero-length strings, they do
not exist at all in the database.
Any help is greatly appreciated