If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Weekly calculations in a daily completed form.
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. |
#2
|
|||
|
|||
Weekly calculations in a daily completed form.
You really only need one query that filters your data so that only records
for the current week are included. "Ken" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Customers- Contracts form problem | GL | Using Forms | 10 | February 7th, 2006 04:05 PM |
Tell if Form is a Dialog | Alex | Using Forms | 7 | August 30th, 2005 06:22 PM |
ECHO Causing Problems | DS | General Discussion | 5 | May 17th, 2005 02:19 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |