Hi!


I have a problem with my query where I am calculating the amount of tax each employee is deducted. Since I've started building this system I've implemented a cost code system for the labour, so I'll know on which project and where on that project my workers are.. The problem I'v got though, is that before I had one entry per week per worker and then calculated the taxes. As for now, workers may have worked on several jobs n several cost codes so I can have up to 5 entries per week for one worker. So when the system is calculating the taxes it is calculating the taxes per entry, not per week and it gives faulty calculations.

anyone who could help me with this? I need to group every entry for the workers into one per week...



Cheers,


Takstein

P.s. I tried to use totals, but keep getting up funny errors and can't seem to find a solution.