Recent content by cobby

Hi Bob, thanks a million for your help, it has worked well but there is another problem which I think requires if and else statement. When you research by putting in the month say 12/2009 its returns the number of records with negative amount in the column like (-4) which I think means 4 records...

thanks very much Bob. I will have a go at it now.

Thanks Wilpeter for your reply. Your suggestion seems very good, just that if I create buttons to calculate a query report for January, February and so on for the year 2010, what about the year 2011 or 2012.... Ideally, I will want a window to popup so users can put in the dates say 01/01/2010...

Please help me do the following calculation for each month time sheet. In my database query, I have the following fields, StaffID, StartTime, EndTime and TotalHours. TotalHours is calculated by finding the time difference between EndTime and StartTime. Now, I want to be able to calculate the sum...