467,173 Members | 1,379 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,173 developers. It's quick & easy.

Grouping Dates and Calculating Hours on a Form

I have created a frmTimesheet form where auditors will enter their hours for audits that they've worked on. I know how to build a very basic, no-frills database, and what I'm trying to accomplish here is a bit beyond my true technical expertise.

At this point, the auditor can select his/her name on the primary Form which will filter any/all audits that they have charged time to (subForm). The subForm details the audits, dates, and hours per audit.

Problem: Some audits have the same date, but different hours associated. Example:

Auditor: Jane Smith
Activity Date Hours
Admin 10/6/07 5
Acctg 10/6/07 3
Training 10/25/07 8

Is there a way on a Form to group like dates and have the hours associated with the like dates to sum, so that one can be assured that they have entered at least 8 hours on a given day?

Thank you
Oct 26 '07 #1
  • viewed: 1359
Share:
4 Replies
beacon
512MB
Are you going to be examining your data on a table or will you eventually create a report?

If you create a report you can insert a count function to total the number of hours worked for a given date. Actually you can do this on the table too.

Let me know if this is something you're interested in.
Oct 26 '07 #2
Are you going to be examining your data on a table or will you eventually create a report?

If you create a report you can insert a count function to total the number of hours worked for a given date. Actually you can do this on the table too.

Let me know if this is something you're interested in.
Beacon-
Of course, I want to make sure that the underlying Table is accurately capturing all data, however, I would be examining the information in a report that I would create.

I am interesting in learning more as to how to do this.

Sounds like I would be unable to do this in a form...???
Oct 29 '07 #3
beacon
512MB
When you create your report, create a footer section for the hours worked and type in the following expression into a text box:
Expand|Select|Wrap|Line Numbers
  1. =Sum(Hours)
  2.  
This will work for you if you setup your report to be grouped by individual and then by date. I said count in the last reply, but I realized that you were actually wanting a total.

You can do the same thing on a form using a text box.

Hope this helps...
Oct 29 '07 #4
When you create your report, create a footer section for the hours worked and type in the following expression into a text box:
Expand|Select|Wrap|Line Numbers
  1. =Sum(Hours)
  2.  
This will work for you if you setup your report to be grouped by individual and then by date. I said count in the last reply, but I realized that you were actually wanting a total.

You can do the same thing on a form using a text box.

Hope this helps...
Awesome, mission accomplished. Thank you much:)
Oct 29 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Mojca | last post: by
16 posts views Thread by Dennis D. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.