Filter a report based on more than one possibility in the same field (1 Viewer)

So, I feel kind of dumb here cause I'm 99% sure this is super easy and already been solved multiple times on this forum but I really can't figure it out after lots of poking around.

I am trying to create a report that filters out certain records in a look-up field.

The field is called "program status", and the options are:
Housed
Evicted/Un-housed
Grad
GRAI
Closed

I want the report to display only records that are classified as "Housed" or "Evicted/Un-housed". Additionally, I'd like to be able to create a second report with only the Grad, GRAI, and Closed records.

I feel like this should be super easy, but have NO idea how to go about this. Any help is much appreciated. (Access 2007, btw)

Should be fairly straightforward, a couple of choices

"SELECT * FROM YourTbl WHERE [Program status] in ('Housed','Evicted/Un-housed')

or

"SELECT * FROM YourTbl WHERE [Program status] ='Housed' OR [Program status] = 'Evicted/Un-housed'"


I am assuming your status is a text value and not a lookup

TIP: best to avoid spaces in fields names

Perfect! Done and done-er! Thanks for the tips!