By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Add numbers from multiple records...

P: n/a
I need to have a textbox (txtTotalCount) add up all the numbers found
in "continuous forms" below it. It needs to add the date found in
txtLineCount that is in each record, txtLineCount finds its number by
=[txtEnd]-[txtStart].

I have tried setting txtTotalCount =sum([txtLineCount]) as well as
tried dsum, all return with #Error.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 18 May 2004 21:19:31 -0700, jo***********@socal.rr.com (Josh
Armstrong) wrote:

In the footer of the form, add a textbox, and set the controlsource
to:
=sum(txtLineCount-txtStart)

-Tom.
I need to have a textbox (txtTotalCount) add up all the numbers found
in "continuous forms" below it. It needs to add the date found in
txtLineCount that is in each record, txtLineCount finds its number by
=[txtEnd]-[txtStart].

I have tried setting txtTotalCount =sum([txtLineCount]) as well as
tried dsum, all return with #Error.


Nov 12 '05 #2

P: n/a
Base your form on a query and create a calculated field in the query:
Diff: =[txtEnd]-[txtStart]

Add the Diff field to your form. Now in your footer place
=Sum([Diff])

Hope it helps!
--
Reggie

www.smittysinet.com
----------
"Josh Armstrong" <jo***********@socal.rr.com> wrote in message
news:b6**************************@posting.google.c om...
I need to have a textbox (txtTotalCount) add up all the numbers found
in "continuous forms" below it. It needs to add the date found in
txtLineCount that is in each record, txtLineCount finds its number by
=[txtEnd]-[txtStart].

I have tried setting txtTotalCount =sum([txtLineCount]) as well as
tried dsum, all return with #Error.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.