Expression to count hours for present day

  • Thread starter Thread starter Chantel33
  • Start date Start date
C

Chantel33

I have the following expression on my form in my Total Hours field:

IIf ( [Processed Date] = Now () , Sum ( [Hours] ) , 0)

I would like for the total hours field to sum the hours entered for the
present day, but i am getting an error. Please help. I would like my total
hours to reflect hours entered and processed for the current day, each day.
 
I have the following expression on my form in my Total Hours field:

IIf ( [Processed Date] = Now () , Sum ( [Hours] ) , 0)

I would like for the total hours field to sum the hours entered for the
present day, but i am getting an error. Please help. I would like my total
hours to reflect hours entered and processed for the current day, each day.
Click to expand...

Now() will basically never equal [Processed Date]. It returns the current date
AND TIME accurate to a few microseconds.

Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?

If you want to go directly to the table rather than the form you could use

=DSum("[Hours]", "[tablename]", "[Processed Date] = #" & Date() & "#")

but I'm not sure that's what you want.
 
I have the following expression on my form in my Total Hours field:

IIf ( [Processed Date] = Now () , Sum ( [Hours] ) , 0)

I would like for the total hours field to sum the hours entered for the
present day, but i am getting an error. Please help. I would like my total
hours to reflect hours entered and processed for the current day, each day.
Click to expand...

Now() will basically never equal [Processed Date]. It returns the current date
AND TIME accurate to a few microseconds.

Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?

If you want to go directly to the table rather than the form you could use

=DSum("[Hours]", "[tablename]", "[Processed Date] = #" & Date() & "#")

but I'm not sure that's what you want.
 
Where is this expression? What is in the [Hours] fields - hours for this
date,
for various dates, or what? What's the context?
Click to expand...
the expression is in the Total Hours field this is an unbound text field

nothing is in the hours field, this is where we enter the total amount of
time spent on a task. The total field was created to sum up those hours but
i only want what is done for today to show up in the total hours field on my
form.

John W. Vinson said:
I have the following expression on my form in my Total Hours field:

IIf ( [Processed Date] = Now () , Sum ( [Hours] ) , 0)

I would like for the total hours field to sum the hours entered for the
present day, but i am getting an error. Please help. I would like my total
hours to reflect hours entered and processed for the current day, each day.
Click to expand...

Now() will basically never equal [Processed Date]. It returns the current date
AND TIME accurate to a few microseconds.

Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?

If you want to go directly to the table rather than the form you could use

=DSum("[Hours]", "[tablename]", "[Processed Date] = #" & Date() & "#")

but I'm not sure that's what you want.
Click to expand...
 
Where is this expression? What is in the [Hours] fields - hours for this
date,
for various dates, or what? What's the context?
Click to expand...
the expression is in the Total Hours field this is an unbound text field

nothing is in the hours field, this is where we enter the total amount of
time spent on a task. The total field was created to sum up those hours but
i only want what is done for today to show up in the total hours field on my
form.

John W. Vinson said:
I have the following expression on my form in my Total Hours field:

IIf ( [Processed Date] = Now () , Sum ( [Hours] ) , 0)

I would like for the total hours field to sum the hours entered for the
present day, but i am getting an error. Please help. I would like my total
hours to reflect hours entered and processed for the current day, each day.
Click to expand...

Now() will basically never equal [Processed Date]. It returns the current date
AND TIME accurate to a few microseconds.

Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?

If you want to go directly to the table rather than the form you could use

=DSum("[Hours]", "[tablename]", "[Processed Date] = #" & Date() & "#")

but I'm not sure that's what you want.
Click to expand...
 
Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?
Click to expand...
the expression is in the Total Hours field this is an unbound text field

nothing is in the hours field, this is where we enter the total amount of
time spent on a task. The total field was created to sum up those hours but
i only want what is done for today to show up in the total hours field on my
form.
Click to expand...

If only today's hours are on the form just use

=Sum([hours])

If the form displays data from several days and you want to sum only those
records that are from today, do the calculation in the Query upon which the
form is based rather than on the form, in a calculated field; and include
*another* calculated field doing the same calculation in an IIF:

IIF([datefield] = Date(), [Hours], 0)

Call this field TodayHours, and in the form footer put a textbox with a
control source
=Sum([TodayHours])
 
Where is this expression? What is in the [Hours] fields - hours for this date,
for various dates, or what? What's the context?
Click to expand...
the expression is in the Total Hours field this is an unbound text field

nothing is in the hours field, this is where we enter the total amount of
time spent on a task. The total field was created to sum up those hours but
i only want what is done for today to show up in the total hours field on my
form.
Click to expand...

If only today's hours are on the form just use

=Sum([hours])

If the form displays data from several days and you want to sum only those
records that are from today, do the calculation in the Query upon which the
form is based rather than on the form, in a calculated field; and include
*another* calculated field doing the same calculation in an IIF:

IIF([datefield] = Date(), [Hours], 0)

Call this field TodayHours, and in the form footer put a textbox with a
control source
=Sum([TodayHours])
 
Back
Top