Sum function

  • 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
 
Drop the SUM. Sum adds up the field for rows of data, what you seem to want
is to calculate the difference within one row.

=([actdate1]-[rprdate])


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top