Need Help with Complicated Totals!!!!!

[Fransdekock]

Hi

I am doing a timesheet database system which records a contractors hours worked in a week and the rate they worked at as well as overtime hours and their respective overtime rates

this is set up as
Week1
Week1Rate
Week2
Week2Rate
Week3
Week3Rate
Week4
Week4Rate
Week5
Week5Rate
OWeek1
OWeek1Rate
OWeek2
OWeek2Rate
OWeek3
OWeek3Rate
OWeek4
OWeek4Rate
OWeek5
OWeek5Rate

No i am doing a report for management where they want to see a complete breakdown of hours worked a month and the respective rate that hours was based on.

SO lets say in week1 a contractor worked 30 hours at £20 an hour and also in week2 but week 3 they worked 20 hours at £35 an hour they report has to show

60 hours at £20
20 Hours at £35

the thing is they could have different or the same rates for each week as well as overtime. I created a new table to hold the values but i was just wondering if their is a quick way to do it rather than to use many many if's and mutliple checks with recordsets.

Any ideas or help will be much appreciated.

Oh yes The data is stored as mentioned above just with a unique indentifier to a month and year.

 

[Summerwind]

I need to create simalar reports in the apps I write. My method is to use ADOX to create a table in the front end. This table is the source of the report. I then use ADODB commands with the relevant SQL clauses to pull in the data I need. This table is then the basis of my report.