If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reporting total number of clients
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 |
#2
|
|||
|
|||
Reporting total number of clients
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 |
#3
|
|||
|
|||
Reporting total number of clients
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 |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
Reporting total number of clients
"Larry Linson" schreef in bericht ... "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? Im am very sure that Steve is triggered by ' OP's statement: 'It's my first time using the program' So of course he is eager trying to 'help' ... mentioning his fee will come afterwards but alas the help is not very good... Arno R |
Thread Tools | |
Display Modes | |
|
|