If I understand the problem correctly, just set the property of the textbox
on the report to be
=dcount(status,my source query or table name,status = 'R' )
_
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 10:56 AM
I will forward to him to see if that works for him...my thanks for the very
quick reply! There are mutliple values that he would like to sum from that
same fieldcan that be done in one formula to return the sum values of that
field for each value type?
C = 25
R = 35
U = 145
Dave
To do that using the formula I provided, you'd either need to put it
different text boxes (which can be stacked in the same column on the detail
band) or you'd need to build a longer formula string and instantiate it as a
text string like There are formula C records, formula R
records, and
great...we'll give them all a trythank you for your help today!
Dave
From: ms_access@yahoogroups.com on behalf of Peter Groman
Sent: Wed 10/24/2007 11:19 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] FW: 0718 AM
To do that using the formula I