Reporting total number of clients

  • Thread starter Thread starter lovelili
  • Start date Start date
L

lovelili

How do i make a report where it totals all of the clients I imput into the
form in Access 2003? Very confused. It's my first time using the program
 
Good comment on basing your report on the table. However:
TotalClient = 1
won't work as a new column in a query.
TotalClient: 1
will work but why use it. In a report footer, you can use a text box with a
control source of:
=Count(*)
to count the number of records in a report.
 
Steve said:
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.
Click to expand...

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?
 
Back
Top