I have a report that uses a query as the recordsource.
One field in the query is called Header which can be either Approved,
Received, Not Taken, Closed Out.
On the report footer - I total each of these by
txtTotalApprove s = Sum(IIF(Header= "Approved",1,0) ). Then I reference
these in the report header as a summary page at the TOP of the
report.
So this works - but I want the detail lines of a group to only include
header types of Closed Out or Not Taken.
I know I could create a subreport, but can a group be filtered
somehow? I tried entering an expression in the grouping :
IIF(Header="Not Taken" or Header="Closed Out",Header), but that still
gave me all status.
Thanks,
Brian
One field in the query is called Header which can be either Approved,
Received, Not Taken, Closed Out.
On the report footer - I total each of these by
txtTotalApprove s = Sum(IIF(Header= "Approved",1,0) ). Then I reference
these in the report header as a summary page at the TOP of the
report.
So this works - but I want the detail lines of a group to only include
header types of Closed Out or Not Taken.
I know I could create a subreport, but can a group be filtered
somehow? I tried entering an expression in the grouping :
IIF(Header="Not Taken" or Header="Closed Out",Header), but that still
gave me all status.
Thanks,
Brian