sum function help

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

I am using the following in a textbox, the output is totaling the whole
field. How can I get to sum the current record instead of the whole field?

=Sum([actdate1]-[rprdate])

Thanks...

Lee
 
I am using the following in a textbox, the output is totaling the whole
field. How can I get to sum the current record instead of the whole field?

=Sum([actdate1]-[rprdate])

Thanks...

Lee
Click to expand...

What do you mean by "sum the current record"?
Each record should only have one [actdate1] value and one [rprdate]
value.
What datatypes are these fields? DateTime?

Either:
=[actdate1]-[rprdate]
or
=DateDiff("d",[actdate1],[rprdate])
should return the number of days between the 2 dates.

If this is not what you are trying to do, then post back giving us
more detail, such as an example of the data in the fields, as well as
the expected result.
 
Back
Top