S
SLA
I have access to a Stats.mdb which is made up of 4 tables.
The StatsBatch table lists the form name and an external
batch id when a form is scanned. The StatsBatchModule
Table lists the external batch id, the action performed
(scan,index,reject,store), the user id, the startdatetime
and enddatetime, the pages deleted, the documents deleted,
the pages scanned and documents created and a unique id.
The StatsFormType table reports the unique id and the
pages rejected and the documents rejected. The 4th table
lists the action performed and the user id. I am supposed
to report the actions performed by each user each day. I
have joined table 1 to table 2, table 2 to table 3 and
table 2 to table 4. I have created a query. A user can
perform more than one action per form name, except scan
which uses a unique User name. How do I layout the report
so that it shows what each user did within each action. I
need it to look like this:
Date: Monday,3 June 2004
Form Name:AddChng Total Pages Scanned : 100
User: ABC Total Documents Created: 10
Pages Del: 9 Docs Dele: 1 Pages Rej: 0 Docs Rej:1
Form Name
romNote Total Pages Scanned: 50
Total Docs Create: 50
Pages Del: 0 Docs Dele: 1 Pages Rej: 0 Docs Rej:0
Total Items Processed by User Name ABC(2 detail records):
Pgs scnnd:150 Docs:60
Pages Del:9 Docs Dele: 2 Pages Rej:0 Docs Rej:1
The StatsBatch table lists the form name and an external
batch id when a form is scanned. The StatsBatchModule
Table lists the external batch id, the action performed
(scan,index,reject,store), the user id, the startdatetime
and enddatetime, the pages deleted, the documents deleted,
the pages scanned and documents created and a unique id.
The StatsFormType table reports the unique id and the
pages rejected and the documents rejected. The 4th table
lists the action performed and the user id. I am supposed
to report the actions performed by each user each day. I
have joined table 1 to table 2, table 2 to table 3 and
table 2 to table 4. I have created a query. A user can
perform more than one action per form name, except scan
which uses a unique User name. How do I layout the report
so that it shows what each user did within each action. I
need it to look like this:
Date: Monday,3 June 2004
Form Name:AddChng Total Pages Scanned : 100
User: ABC Total Documents Created: 10
Pages Del: 9 Docs Dele: 1 Pages Rej: 0 Docs Rej:1
Form Name
romNote Total Pages Scanned: 50Total Docs Create: 50
Pages Del: 0 Docs Dele: 1 Pages Rej: 0 Docs Rej:0
Total Items Processed by User Name ABC(2 detail records):
Pgs scnnd:150 Docs:60
Pages Del:9 Docs Dele: 2 Pages Rej:0 Docs Rej:1