This report designer is a powerful visual tool that you can use to build, test, and save SQL statements for use in application data queries.
In the query screen, the SQL sentence can be directly typed in the box. However, most of cases is easier to use the wizard clicking Wizard button.
The above example shows a list of females and their entry date.
How to do a simple query
A simple query is list of row from a single table, selecting the variables to see, filtered by criteria and sorted by 1 or more variables.
| 1. | The available tables appear in the right side of the screen. Drag and drop the table that you need to use to left side. |
| 2. | In the field list box, select the fields that you want to see. |
| 3. | Click Criteria sheet |
| 4. | Double click the first empty cell. The Expression builder should appear. |
| 5. | Enter the filter and click Ok |
| 6. | Click Sorting sheet |
| 7. | Select the variable to sort and click Add. You can order by more than 1 variable. |
| 8. | Click SQL button to generate the SQL statement. |
| 9. | Click Run SQL button to see the results of your query. |
| 10. | Click Accept Query to close the wizard |
Some examples:
Active unmated breeding females