Do you know… Blue Mountain RAM’s Quick Find Tool Accepts Multiple Criteria?
Open a query in Blue Mountain RAM and see a very helpful button: Quick Find . The Quick Find Tool will apply single or multiple criteria to any query you wish to search.
The first time you click Quick Find , a criteria statement bar appears:
Use Field Pick List to select a column you wish to search in the current query (you may wish to add more fields to a query to facilitate your searching needs).
Use Function Pick List to specify how you want a criterion evaluated.
Use Criterion Field to enter the criterion.
Field Values opens a window for Begins With searching in the selected column.
Find initiates a search for the criteria statement(s) as entered.
Add opens additional criteria statement rows (one for each click).
Remove appears when there are multiple criteria; it remove the adjacent statement.
Two Examples of Employing Multiple Criteria Statements:
- Pulling up a date range of scheduled work (using “All Asset Schedules” query)
- Criterion #1 – Due Date Greater Than or Equal To 4/1/2015
- Join Operator (And/Or) – AND
- Criterion #2 – Due Date Less Than or Equal To 4/30/2015
Click Refresh on the Query Toolbar to clear the current search.
- Pulling up a list of one person’s open work (using “All Calibration Work” query)
- Criterion #1 – Assigned Person Equal To George Carlson
- Join Operator (And/Or) – AND
- Criterion #2 – Status Equal To Open
For further information, consult your Blue Mountain RAM manuals. If necessary, contact us for downloads of PDFs of the manuals. Also, please enjoy calling and speaking with your Regional Sales Manager (RSM) at 800-982-2388 if you have questions or are interested in Blue Mountain RAM training.