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: ms_access@yahoogroups.com on behalf of Peter Groman Sent: Wed 10/24/2007 11:05 AM To: ms_access@yahoogroups.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: ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com> [mailto:ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Dave Moreau Sent: Wednesday, October 24, 2007 10:56 AM To: ms_access@yahoogroups.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.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctW <http://www.cafemessenger.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]