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 " & formula & " U records in the database". Which probably
would not fit in the space provided.
You could also use a VBA function. Set the text box property to
=MyFunctinoName() And then write a function in the general module lie
this:
Public Function MyFunctionName()
Dim txt1 as string
Dim txt3 as string
Dim txt4 as string
txt1 = "C = " & dcount("status","my source query or table name","status
= 'C' ") & CTRLF(10) & CTRLF(13)
txt2 = "U = " &dcount("status","my source query or table name","status =
'U' ") & CTRLF(10) & CTRLF(13)
txt3 = "R = " & dcount("status","my source query or table name","status
= 'R' ") & CTRLF(10) & CTRLF(13)
MyFunctioName = txt1 & txt2 & txt3
End Function
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 11:05 AM
To: [email protected]
Subject: RE: [ms_access] FW: 0718 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 field....can 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
________________________________
From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com on
behalf of Peter Groman
Sent: Wed 10/24/2007 11:05 AM
To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com
Subject: RE: [ms_access] FW: 0718 AM
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: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com
<mailto:ms_access%40yahoogroups.com> [mailto:[EMAIL PROTECTED]
<mailto:ms_access%40yahoogroups.com> ps.com
<mailto:ms_access%40yahoogroups.com> ] On Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 10:56 AM
To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com
<mailto:ms_access%40yahoogroups.com>
Subject: [ms_access] FW: 0718 AM
can this group help out the gent below? I will forward your reply to the
group to him
his field name is [status] and it has listed as values in it either a C, R,
U
________________________________
From: Derek Hess
Sent: Wed 10/24/2007 10:16 AM
To: Dave Moreau
Subject: RE: 0718 AM
Sure, I can try. Here goes.
In the report header we have a text box. Within that text box we would like
to have an expression that counts records from within the report below, that
equals a particular letter (value) in a specific column. For example:
The column in question has letters ('C', 'R', 'U', etc)
When the value within that column is an 'R' we would like to have the count
displayed, so of lets say 400 records, if 36 have 'R' in that column, the
textbox should display 36 not 0 or 400.
Is this clear enough??
-Derek
<http://www.cafemess <http://www.cafemess <http://www.cafemess/> />
<http://www.cafemess
<http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctW
> enger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctW
<http://www.cafemess
<http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctW
> enger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctW>
Ltagline> enger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline>
This e-mail and any attachments may be confidential or legally privileged.
[Non-text portions of this message have been removed]
This e-mail and any attachments may be confidential or legally privileged.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
