Filtering Grouped items from report

[dawnd3]

Hi there,

I would like to know if it is possible to filter records at the report level. I have a report that is grouped by Vendor name with the transaction totals in the group footer. I would like to be able to filter out any vendors and their transactions (the entire group) if their total amount does not meet a certain criteria. Can I do this in the report? I can't do it in the query because I need to have the individual transactions to feed into the report.

thanks for any help.

Dawn

http://www.calliopeconsulting.net

 

[dawnd3]

I found a way to do this. I just created another query that grouped the records and filtered based on the minimum value I wanted and then linked that query with the original (by vendor ID) one in a new query to give me the records I needed for the report.

Can I give myself a star?

Dawn

http://www.calliopeconsulting.net