Hide Grouped Records

[raffi]

hello, is there a way to hide grouped records in a query? in a sense where 2 of the same records get hidden when they group up, and when a change has been made to one of the records, the two records will unhide/appear cuz they aren't grouped anymore since we made changes to one of them.

[ranman256]

No.
if you don't want to see the record, filter it out of the query.

[pbaldy]

You could use a totals query and use Group By on the appropriate fields, Sum/Max/whatever on the others.

[June7]

Records don't 'hide', not like rows can be hidden in an Excel sheet. Records are in query or not in query as determined by filter criteria.