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.

--
Duane Hookom
Microsoft Access MVP


"Steve" wrote:

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.

Steve



"lovelili" wrote in message
...
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