jeffreybrown
Registered User.
- Local time
- Yesterday, 23:59
- Joined
- Aug 13, 2010
- Messages
- 15
I have a report with a query as the control source. Because of multiple tables the query is producing duplicate names which is fine as one field makes each record unique.
On the form in a textbox I have =Count(*) which counts all of the records, but it's counting the duplicate names as one.
How can I get the count to eliminate and give a count of unique names?
On the form in a textbox I have =Count(*) which counts all of the records, but it's counting the duplicate names as one.
How can I get the count to eliminate and give a count of unique names?