Richard,

Excuse me for the delay - I was very busy this weekend, and didn't check into the UT.

If you have a field DataClerk, which says who modified a record, you can GROUP BY DataClerk, and include the field COUNT(*) AS RECORDS_ENTERED, to indicate how many records are modified by each person. You can ORDER BY ... DESCENDING, to have the person who entered most data at the top. You can have a second SELECT ... SUM(RECORDS_ENTERED) (into a second table) for the grand total. Or GROUP BY department. Or by table. Compare with this table for the percentages. And UNION to combine data from two tables.

Please write back if anything isn't clear, or if you need anything else.

Hilmar.

>Hi Hilmar,
> Actually it's an Application I'm trying to modify to siut whatever I want. There's a form which creates the DataEnviroment of the report on the fly, such that when you choose preview you can preview the report. The report is supposed to output a Data Entry summary of different data clerks and the number of records they have updated in 2 different tables.
> That, I have done ...... what I want is to have the totals of the records entered by each data clerk on the two tables and the percentage of the grand total of the data entered by each data clerk in this format.
>
>Data Clerk
>Rich.
>
>Table number of Total records % of Grand
>updated records entered Total
>
>table1 10
>table2 20 30 37.5
>
>Data Clerk
>Hilmar
>
>Table number of Total records % of Grand
>updated records entered Total
>
>table1 20
>table2 30 50 62.5
>
>
>
>Thanks in advance.
>
>Richard.