I would like to create a list of all active unmated breeding females in my herd.
Use Query report designer. The setup screen is shown below:
Tables: |
FEMALEEX |
Columns: |
ID, ENTRYDATE |
Criteria: |
ISACTIVE=1 AND STATUSCODE='E' |
Sorting: |
ENTRYDATE, ID |
Or you can use SQL directly:
SELECT ID, ENTRYDATE FROM FEMALEEX
WHERE ISACTIVE=1 AND STATUSCODE='E'
ORDER BY ENTRYDATE, ID
The Query report is shown below:
