|Definition||Example Scenario...||...Example Criteria |
& Field Selection
|Finds values less than the criteria||If you were searching for invoices totaling $1499.99 and below...||...then enter <1500.00 for the Balance field.|
|Less than or equal to |
≤ or <=
|Finds values less than or equal to the criteria||If you were searching for all timesheets created on or before 3/1/2007...||...then enter <=3/1/2007 for the Date field.|
|Greater than |
|Finds values greater than what you enter||If you were searching for timesheets with hours greater than 3...||...then enter >3 for the Hours field.|
|Greater than or equal to |
≥ or >=
|Finds values greater than or equal to what you enter||If you were searching for invoices totaling $1500.00 and more...||...then enter >=1500.00 for the Balance field.|
|Exact match of whole word (or match Empty)||If you were searching for a line item code with the word "Market" in the title or for invoices equal to $1500.00...||...then enter =market for the Line Item Code Name field or enter =1500.00 for the Balance field. (Note: This example would find "Market Research" and "General Market", but not "Marketing".)|
|Exact match in the field||If you were searching for a company named "Auto Zone", but not "Custom Auto"...||...then enter ==Auto Zone for the Company field.|
|Finds records within a range||If you were searching for records on or between two dates or matching or between two invoices numbers...||...then enter 1/1/2007…1/31/2007 for the Date field or enter 10000…10003 for the Invoice # field.|
|Finds records with duplicate field values||If you were searching for all duplicate company records...||...then enter ! for the Company Name field.|
|Double forward slash|
|Finds records with today’s date||If you were searching for all Company records entered today...||...then enter // for the Creation Date field.|
|Single character variable |
|Replaces a single unknown or variable character||If you were searching for a name, but unsure of the exact spelling (e.g. "Gray" or "Grey")...||...then enter Gr@y for the Name field.|
|Replaces an unlimited number of unknown characters||If you were searching for a name, but unsure of the spelling...||...then enter sch* for the Name field to return all names starting with "Sch", like "Schwartz" and "Schwin". Likewise, enter *son* for the Name field to return all variations containing "son", like "Richardson" and "Sonamaker".|
|Finds the exact criteria entered between the quotation marks, often used for spaces and punctuation||If you were searching for a company with a comma in the company name, such as "Smith, Webster, and Jones"...||...enter “,” for the Last Name field to return all records with a comma in the name. Likewise, enter “, LTD” for the Company Name to find all companies with that abbreviation.|
Searching with Dates
aACE includes robust search features for Date fields. Examples of the types of searches you can perform include:
- Search for a specific day's records — Enter a full date (e.g. "1/2/2019").
- Search for a single month's records — Enter a month and year (e.g. "3/2019") to display all records within that month.
- Search for a single year's records — Enter a year (e.g. "2019") to display all records within that calendar year.
- Search for records in a date range — Enter a month/day/year set (e.g. "4/15/2019...5/07/2019") to display all records within that range.
- Search for records in a range of months — Enter a month/year set (e.g. "1/2019...2/2019") to display all records in those months.
Note: Depending on the module you are viewing and the current sorting settings, the records in the results list may be sequenced in an order other than by date.