Grouping Dates and Calculating Hours on a Form

jnice814

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

beacon

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

jnice814

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

When you create your report, create a footer section for the hours worked and type in the following expression into a text box:
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

jnice814

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