View Single Post
  #4  
Old August 19th, 2009, 09:04 AM posted to microsoft.public.access.reports
Larry Linson
external usenet poster
 
Posts: 3,112
Default Reporting total number of clients

"Steve" wrote in message
m...
All yhe clients you enter in a form are saved to a table. Create a query
based on this table. Base your report on the query. To get the total of
clients, enter this expression in a blank field in your query:
TotalClient = 1
Include the filed TotalClient in your report as the first field in each
record. The TotalClient field will then number all your records and the
last record will be the total clients.


It will not "number all your records" unless you choose Running Sum Over All
for the text box in which you display it, will it, now?