How Calculate Hours By week

[christ2000]

Hello guys, I need to access allow me calculate hours by week, I have two fields with dates, and then another field that show me the total hours in each week, and not counts the hours that are from deferent weeks

thanks

[isladogs]

You need to define the week number for each date.
Is your week Sun to Sat? Or something else
You will use built in access functions for Week, Weekday.

[ranman256]

make a form, on it are 2 unbound data fields...txtStartDate and txtEndDate
user enters the start date of the week into txtStartDate
then code can set the end date txtEndDate = dateadd("d",6,txtStartDate)

now run a query using these: (and calc elapsed time from the 2 fields in the table)

select *, DateDiff("h",[start],[end]) as ElapsedTime from table where [date] between forms!myForm!.txtStartDate and forms!myForm!.txtEndDate

sum the time in a report or sum query.