Weekly calculations in a daily completed form.

[Ken]

I have a database of work done each day, date, time ec't, on the form
there are fields for start date, finish date, start time, finish time,
breaks, week day, week number and worked hours amongst other things,
these are records for each day, I would like to add a field on the
form to show the total hours for the current week, is this possible or
do I need to open queries each time I want to see this information.

Thanks in advance for any advise given.

 

[Guest]

You really only need one query that filters your data so that only records
for the current week are included.