I need to work out the overtime by week for a table of employees. The information that I have is hours worked per day and my query is set up to show only the latest month. So, I am able to total the hours worked for the month however, I want to work out what the overtime is and this needs to be worked out on a weekly basis, not daily or monthly. Any suggestions? I need to know what and where - only in query veiw please as the VB baffles me!
Many thanks, in advance.
Hi, thanks once again for your help!
However, I am confused a little - where you state 2,2 - I assume this refers to the number of rows and columns. What if I have an unknown number of rows and apx 15 columns?