User Reports 1. List the patient id, accession id, animal name, and breed for all animals, sorted by animal type, that are currently being treated (where they have not been released, or sent to a...

User Reports 1. List the patient id, accession id, animal name, and breed for all animals, sorted by animal type, that are currently being treated (where they have not been released, or sent to a carer or other facility). 2. List all animals with a microchip, Qld Parks and Wildlife Id or ear tag within a given time period (ie. A month or year) 3. Monthly report (this is multiple queries): a. list the total for all in-coming accessions in the previous calendar month grouped by i. Diagnosis/Aetiology ii. Taxon group iii. Local government area iv. Cause of affliction b. List the total number of accessions for this month in the previous years. c. List the total number of accessions for each month in the previous 12 months. 4. List all Koalas in 2009 that were treated for Chlamydial Conjunctivitis