Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count on the column

Status
Not open for further replies.
syedmca

syedmca

Technical User
Jul 28, 2007
16
IN
Hi,


I need to count the number of times AAAAA,BBBB

AAAAA
BBBBB
CCCCCC
AAAAA
BBBBB
BBBBB

count
----
AAAA= 2
BBBB=3
CCCC=1

Regards
syed
 
Sort by date Sort by votes
Just create a Running totals for each category

In RT editor select your field, in summary select count on evaluate select the formula box and for each category enter

{Filedname} = 'AAAAA'
for next
{Filedname} = 'BBBBB'

etc.

Ian
 
Upvote 0 Downvote
You could also insert a crosstab in the report footer, this will count things automatically.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
550
hilfy
hilfy
J
  • Locked
  • Question
New page before when a detail section last on page.
Replies
1
Views
382
hilfy
hilfy
socalvelo
  • Locked
  • Question
Group Sorting Distinct Count Minimum
Replies
2
Views
199
socalvelo
socalvelo
cursedkorok
  • Locked
  • Question
Transpose Columns into Rows?
Replies
1
Views
306
hilfy
hilfy
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
275
Paulo R
Paulo R

Part and Inventory Search

Sponsor

Back
Top