In regular FileMaker, enter find mode and select the first value (active). Select new request from the requests menu. Select the next value (occupied). Select new request and select the third value (pending).
Now perform your find and you will find the records where this field stores active, occupied, or pending.
This can also be scripted.
I don't really understand scripting. Does that allow me to save a particular search?
I guess what I am trying to say, so my staff doesn't have to always type in the search field what they want I can already have a report created with what they need to see? If this is different do you know how to do this?
A script can enter find mode and enter the criteria and create new requests for the user. If this is a canned search that should always use the same criteria, you might make a script similar to this, but using your table and field names in place of mine:
Enter Find Mode  //clear the pause check box
Set field [YourTable::YourField ; "active"]
Set Field [YourTable::yourFiled ; "Occupied"]
Set Field [YourTable::yourFiled ; "Pending"]
Set error capture [on] // prevents "no records found" from interrupting your script with a dialog box
If you want the user to enter criteria to be used as part of your scripted find, you can put global fields on your layout where they enter that criteria before performing the script and your script can then use set field steps like I have above, but in place of a constant value in quotes you'd refer to that global field. (Field must have global storage specified in order for this to work.)
Here's an example of that step:
Set Field [Yourtable::YourField ; YourTable::gStatus]
Where gStatus would be a global text field where your user enters a criterion for the find.