How can I removed an entire group
No idea what that means. You don't remove records from a grouping, otherwise there'd be nothing to group on. Maybe you are getting ahead of yourself. You create a query that returns the needed fields/records. Then create a report. Then do sorting and grouping in the report design.
If you have 2 or more tables you'd need to join them in query design. If you can't, you will probably have to create a UNION query to base the report on. Unless I'm just testing something, I'll always start with a working query before creating a form or report otherwise the foundation is no good.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.