So where is the data stored? is there a third table with the salary?
Assuming that is the case, the report would be based in the salary table, simply calculate the month based on the date for each record.
Calculate the Week (Honestly I would just use WeekofYear for this and do away with the Time_Table unless it's needed for something else, you can calculate start and end dates for display purposes)
Then do a report with 3 subsummaries, Employee, Month, Week and sort in that order.
Then one Summary Field to calculate the Total.
No third table
1 table - Employee
1 table - TIme Entry for employee
Which all the data is entered & calculated!
So you are saying:
Add a Salary table, but would i create a calculation for calculating the week using WeekOfYear Function?
i need the time table for time in and time out, vacation time, hours worked,etc though.
so summarize by EMPID, Month( in salary table), week ( in time table)
Ok you listed your time table before as "month" which didn't make sense to me. Those 2 should be fine, just calculate the month and week for each time record, and use those to pull your sub summaries for your report.
Digital Carpentry LLC
"Let us build a foundation for your business."