My Query is Not Returning the Records I want on my Report ​
If you query is not returning the records you want:
- Edit the query and verify it is still correct. Some users will edit a query but forgot to rename it so another user doesn't know it has been changed.
- Check the bracketing of your query items. Some queries cannot be reliably used unless elements are bracketed to determine the order of execution of the elements.
- You may need to set a filter on data then use the filter in your query. For example, check the Report Flag on all records with a specific Interest code then use the Report Flag is false option in your query. For help with setting filters, contact your ACEware technician.