sum function help

[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

 

[fredg]

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

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.