normally you use "fieldname" inside the Count() SQL function.
the problem of using field, whether you have Criteria on your query or not on that field, the Query engine will evaluate the field if it is Null or Not.
if it is Not Null, it is included in the Count, if Null, ignored.
using Constant (like "1", or any expression) results in much faster execution since no field is evaluated.
you can create as many query as you like to satisfy what you need.
in this case, you want those issues on separate lines so create new query (4_qryReportPurpose).
then based on that query create the report.
note (on design view of the report), the 3 first fields property (Property->Format->Hide Duplicates) are set to Yes.
you can only do this on the report (hide dups) and not on the form.
Reply With Quote