Sanjay,
Yes it's clear what you wish to do. What you need is a variable that totals ONLY for specific code values. For example:

Code1Var = iif(code=1, Hours, 0)

When you sum this variable at the group level it should add ONLY the code=1 values. You'd have to make a variable for each code type, of course.

HTH
Barbara

>Thanks for your reply. I hope this example of the report I am trying to produce makes it clearer.
>
>EMPLOYEE 1
>

>DATE,            HOURS,      CODE,       ACCOUNT NO.
>1/1/1999,         10,         1,          123456
>1/1/1999,         15,         2,          789123
>1/2/1999,         05,         1,          123456
>1/3/1999,         20,         3,          123456
>1/4/1999,         10,         3,          123456
>
>TOTALS:
>                 15,         1,          123456
>                 15,         2,          789123
>                 30,         3,          123456
>
>EMPLOYEE 2........

>
>
>The TOTALS are based on groupings on the CODE field. The number of CODEs can vary depending on user selection of the date range. I am try to put the TOTALS values on the report:

>TOTALS:
>                 15,         1,          123456
>                 15,         2,          789123
>                 30,         3,          123456
>

>Thanks in advance
>
>Sanjay