Use the drop down menu to select what you would like to search for. The Basic Find allows you to pick from the following:
Where ( 1st field )
Use the drop down menu to select the field name of the data you would like to search for. The list of fields will vary depending on what you have selected for Find What. Note: The term above Where will reflect what you have selected for Find What. The example above says Orders since Order was selected for Find What.
Where ( 2nd field )
Use the drop down menu to select an Operator for your search criteria. The Basic Find allows you to pick from the following:
Does Not Equal
Greater Than Or Equal To
Less Than Or Equal To
Where ( 3rd field )
Enter the value for the search criteria you are looking for. Depending on what you are searching for, this field can accept a number, date or text. In the example above, we are looking for all orders that were placed Yesterday. If you are searching for date related information, you can used the drop down menu to select one of the following:
AND / OR
If you need to add additional search criteria, you can select AND / OR in the field located under the Where section. For example, if I wanted to only show the orders placed Yesterday for a certain customer, I can add additional search criteria to the example above by selecting AND and adding Customer ID Equals, than entering the customer number. Note: I can select up to 4 different search criteria in order to help with your search.
Click to Clear out all of the search criteria you have selected.
You can enter a Description for the query you have created and if you choose to save the query, the Description will help describe what information is displayed in the results of the query. Note: All of the queries created by CXT Software contain a description.
Allow Text Wrap
If selected, this will allow the text to flow down so that all of the data is visible.
Allows you to select a Report Format to display the results of your query, if any. Note: A Report Format is unique to the data that is being returned by the query.
Click to perform the search based on the search criteria.
Click to open the selected result. In the example above, clicking OK will open the order form for the order that is selected in the results. Note: Double clicking the selected row will also work like the OK button.
Click to close the Find and cancel your search.
The area located at the bottom of the Find. This will display the results of your query.