Sum function

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
 
J

John Spencer

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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum function help 1
Finding the right style field in VBA 0
Use TODAY() function as the criteria in a SUMIF formula 1
Need Help Combining Records with Duplicate in some fields 0
Finding the proper style field and the numbered paragraph value within the style 0
Format field to Percent w/ 2 decimal places using IIF statement 4
Get percentage of whole 2
Sum data using sumif 3

Top