Addition

Lyndseyd

Registered User.
Local time
Today, 02:46
Joined
Jul 6, 2005
Messages
71
hi, i have a form which shows all of the transaction that have happened in the business, a field in the form is 'logged by'. The 'logged by' field records the name of the person who completed the transaction. For monitoring the employees performance i have created a query which shows all of the transactions each employee has done, ie there is a promt for the users name to be typed in, then all there transactions are brought up. I now want to produce a report off this, but with the total of transactions the particular employee has done at the top of each page of the report. Basically i want the value it says in the record selectors at the bottom of the record, the total number of each employees transactions. I have tried doing a calculation in the query, adding the amount of auto numbers up, but that doesnt work. Not really sure where i should start from..any tips? :confused:
 
Look at the grouping and summary options in the report wizard. You don't need to do this in the underlying query.
 

Users who are viewing this thread

Back
Top Bottom