Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Summary field in Access Report
I have tried this by creating a Customer Name group using sorting and grouping. I then placed the following in the control for an unbound text box "=Count([CUSTOMER NAME])" in the location footer and it gives me the total number of records, once again, not the number of patients within that...- rogihead
- Post #3
- Forum: Microsoft: Access Reports
-
Summary field in Access Report
I'm having a problem with a count of the distinct names in a listing. What I have is a report that lists sales by location and I need to get a count of the distinct names of patients in each location. The way it is working now is that it counts each record but that does not give me the number...- rogihead
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
