G
Guest
I am a new, self taught, Access user, and I am wondering if someone could
walk me through how to filter a report to show only the subgroups that meet a
certain criteria?
For example I have a report that is grouped by sales person, then by
contractor, then the sales are listed by date under that. I want to be able
to have a report that shows by sales person which contractors have not had
sales with us in the last six months. So in other words if we have had a
sale/sales to them since 10/1/05 I do not want them to show up on the report,
but if we have not than I want to see the contractor and when we last sold to
them.
Sample Report
Sales Person 1
Contractor A
9/30/05 Sold Materials $500
Contractor C
3/15/04 Sold Materials $400
walk me through how to filter a report to show only the subgroups that meet a
certain criteria?
For example I have a report that is grouped by sales person, then by
contractor, then the sales are listed by date under that. I want to be able
to have a report that shows by sales person which contractors have not had
sales with us in the last six months. So in other words if we have had a
sale/sales to them since 10/1/05 I do not want them to show up on the report,
but if we have not than I want to see the contractor and when we last sold to
them.
Sample Report
Sales Person 1
Contractor A
9/30/05 Sold Materials $500
Contractor C
3/15/04 Sold Materials $400