You can either use the query builder: Queries tab, click new, right click on the grey portion and select "SQL View". Type in the query that was offered and click the red ! to test it. It'll open a tableview list of the records that meet the criteria.
You can also build reports to do this and use the SQL as a filter on the open report command.
Sam, good luck