Sum and Count Function

  • Thread starter Thread starter Leon
  • Start date Start date
L

Leon

I am very new to access and have compiled a few reports.
All I want to do is have the a total for a particular
field matching a certain criteria. For instance I have a
field named "code". At the end of the report I am looking
for the Count of how many records in this field begining
with "C" there are (or begining with any other letter).

This might be very lame but I am struggling with the
syntax.

Apologies for this but like I say I am very new. Many
thanks in anticipation of a response.
Leon
 
I am very new to access and have compiled a few reports.
All I want to do is have the a total for a particular
field matching a certain criteria. For instance I have a
field named "code". At the end of the report I am looking
for the Count of how many records in this field begining
with "C" there are (or begining with any other letter).
Click to expand...

In the report footer, you should have a textbox to display this value - set its
"Control Source" to:

=Abs(Sum(
Code: 
 like "C*"))

Obviously, you would need to have a separate textbox for each value of "code"
that  you want a count on.
 
Thanks very much for that, it's a start and it works. Much
appreciated.
-----Original Message-----
I am very new to access and have compiled a few reports.
All I want to do is have the a total for a particular
field matching a certain criteria. For instance I have a
field named "code". At the end of the report I am looking
for the Count of how many records in this field begining
with "C" there are (or begining with any other letter).
Click to expand...

In the report footer, you should have a textbox to display this value - set its
"Control Source" to:

=Abs(Sum(
Code: 
 like "C*"))

Obviously, you would need to have a separate textbox for each value of "code"
that  you want a count on.

--
Bruce M. Thompson, Microsoft Access MVP
[email protected] (See the Access FAQ at http://www.mvps.org/access)within the newsgroups so that all might benefit.<<


.
[/QUOTE]
Click to expand...
 
Back
Top