Can I run a query off of filtered data?

[mnickell]

I am creating a data base for inter-company transactions between different entities in my company. I have joined all of the transactions for the entire year in a union query. I need to be able to filter multiple Entities over a range of dates to be able to generate a report for only those entities that I have selected. I have figured out the range of dates with the between function but can not seem to figure out how to get the entities filtered. Any help would be greatly appreciated

[ItsMe]

Filters are usually applied to datasets via Form Objects. This way, a user can dynamically update the Criteria, causing a filter effect.