This is a problem with the report writer i been stuck with for many years now and i'm still searching for a general solution. Yes, a variable is a solution if you know what codes there will be in the report, but many times you don't know. What I would like to have is in the group footer to have a sum field that prints the sum for every code I've used... I know this is not so easy to do with way the report writer works, but maybe someone has solved it or is there a third party product who can do it?

/Mårten Törnquist

>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