Hello-I have a report which is generated by a form where a date range is selected. The report gives a list of "transactions" listed per "document". One document could have multiple transactions. I just need a text box that counts the unique number of documents. Say there may be 50 transactions in 30 documents, I need to come up with the number 30. The report has a fairly complex query, since the date interval is involved, etc. I have tried many ways, some recommended by users of other forums, but to no avail. I can "COUNT" the number of "documents" using "count" on each detail line to get the number "1", but even trying to sum these up still gives me the number of transactions, not the number of "documents'. Anybody here help?
Thanks

Are you grouping your report based on Documents? In which case, the document text box would only be represented on the report once for each document. Then you just count the documents in the report footer to get the actual total number of documents.

HTH.