Taking information from a table which includes name, hours scheduled for a week and if the person is full time and relating it to a query by last name and first name and the hours worked each day in a week.

I am unable to get a correct total by using sum in the total, by date (using where in the total).

Any suggestions?

If the Hours Worked field is a Date/Time Data Type then take a look at this article to learn how to add time in Access.

http://support.microsoft.com/support/kb/articles/Q88/6/57.ASP?LN=EN-US&SD=gn&FR=0&qry=q88657&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Thank you, you lead me in the right direction. By dividing by 24, I received the correct answers.