Calculate field sum of today

[Chantel33]

I am designing a form that will have multi users and once they enter the
hours worked on a task i have a refesh button to total in the total hours
field, the problem is this is an ongoing database and i would like the Total
of hours to reflect the hours total for the current date or for the processed
date so far i have =Sum([Hours]) in the total field....please help

Chantel

 

[Philip Herlihy]

I am designing a form that will have multi users and once they enter the
hours worked on a task i have a refesh button to total in the total hours
field, the problem is this is an ongoing database and i would like the Total
of hours to reflect the hours total for the current date or for the processed
date so far i have =Sum([Hours]) in the total field....please help

Chantel

I have to say I'm not entirely clear what it is you need, so these are
general suggestions:

To get a form right, you have to get the underlying query right. Most
databases have their information organised into a number of related tables
(See: http://tinyurl.com/ms-table-design-tutorial)
.... and so you need a query to "join" related information together.
Queries can also be used to simplify things, returning only the data you
need for a particular form. So, make sure you have a query which
returns (I'm guessing): Person, Date, HoursWorked.

Then use the Form Builder Wizard to create a new form. (Run this as
often as you need until you get it right, deleting previous attempts.)

Look especially for the options to Summarise and Group your data. I'd
guess you may want to summarise by summing hours, and to group your data
by month or day.

You may also like to look up Crosstab queries in help.

Hope that helps,

Phil, London

 

[Chantel33]

I'm sorry i was babbling.... I need to know if it is possible to limit the
hours totaled in my total hours field to the current date only. I want to be
able to keep track of my total time spent as i enter it.

if i enter 1.25 hours for one task
..75 hours for another task
..50 hous for another task it currently totals up in my "Total hours" field.

this is a ongoing database so as i open the form each day to record my time,
i would like to keep up my time for that current day. Is there an expression
that i can enter to make this happen. is there something i can add to
=Sum([Hours]) to get these results

 

[John W. Vinson]

I'm sorry i was babbling.... I need to know if it is possible to limit the
hours totaled in my total hours field to the current date only. I want to be
able to keep track of my total time spent as i enter it.

if i enter 1.25 hours for one task
.75 hours for another task
.50 hous for another task it currently totals up in my "Total hours" field.

this is a ongoing database so as i open the form each day to record my time,
i would like to keep up my time for that current day. Is there an expression
that i can enter to make this happen. is there something i can add to
=Sum([Hours]) to get these results

Base your Form on a query with a criterion

= Date()

on the date field, and you'll see (and sum) only records from the current
date.

Warning: it means that your computer will turn into a pumpkin at midnight.

 

[AccessVandal via AccessMonster.com]

Darn, and I don't have a costume ready for the party!

 

[Chantel33]

Hey not funny, that sacared me! LOL Thank you! : )

I'm sorry i was babbling.... I need to know if it is possible to limit the
hours totaled in my total hours field to the current date only. I want to be
able to keep track of my total time spent as i enter it.

if i enter 1.25 hours for one task
.75 hours for another task
.50 hous for another task it currently totals up in my "Total hours" field.

this is a ongoing database so as i open the form each day to record my time,
i would like to keep up my time for that current day. Is there an expression
that i can enter to make this happen. is there something i can add to
=Sum([Hours]) to get these results

Base your Form on a query with a criterion

= Date()

on the date field, and you'll see (and sum) only records from the current
date.

Warning: it means that your computer will turn into a pumpkin at midnight.

 

[John W. Vinson]

Hey not funny, that sacared me! LOL Thank you! : )

If you think that's scary wait till you see the wicked stepsisters!