It's been awhile since I've used Access. Anyway, I would like to filter on a Report. If the ENTITY_MILESTONE field contains both "Full Package Received" and "Collateral Upload Complete-Forward..." for each separate header, then I don't want to see these records.

such as:
if([ENTITY_MILESTONE] = ( "Full Package Received", "Collateral Upload Complete-Forwarded for One Point Updates")).

I put this in the Report Filter section. Can someone help?
Thank you.

CC