Hi,
I have an Access report which is based on a table containing 3 fields: CustomerName, Status, and Product.
I am grouping by CustomerName first and Status second.
At the end of the report, I would like to provide a count
of each of the different Products which appeared in the
report. If the report were based on a static query, then
I think that I could set up a summary query based on
the query used by the main report, and group by Product
in the subreport and then get the count of each Product.
But I'm setting the report's RecordSource attribute
from Visual Basic, so the report is not based on a static
query. Is there some way to define the data source of
a report's subreport by saying something like
"parent.query"? Or is there a different and better approach
that I'm overlooking?
Thanks,
Ken Hjulstrom
Senior Software Engineer
Escher Group, Ltd.
I have an Access report which is based on a table containing 3 fields: CustomerName, Status, and Product.
I am grouping by CustomerName first and Status second.
At the end of the report, I would like to provide a count
of each of the different Products which appeared in the
report. If the report were based on a static query, then
I think that I could set up a summary query based on
the query used by the main report, and group by Product
in the subreport and then get the count of each Product.
But I'm setting the report's RecordSource attribute
from Visual Basic, so the report is not based on a static
query. Is there some way to define the data source of
a report's subreport by saying something like
"parent.query"? Or is there a different and better approach
that I'm overlooking?
Thanks,
Ken Hjulstrom
Senior Software Engineer
Escher Group, Ltd.
