need a count of items of same type in a group footer - cr10 2

[inncoggnitto]

db is paradox (yea, i know) and using cr10 -

i have a column that contains codes 1, 2, 6A, 6X, etc. in the details section which is within two groups, but a team and individual.

no problem getting a total count of the items in the section but i also want to count of each of the occurances of each code.

say i have six 1, three 2, four 6A, and two 6X for a total of fifteen occurances.

i want the results to look like

Code 1 - 6
Code 2 - 3
Code 6A - 4
Code 6X - 2
Total Count - 15 (this one is easy)

do i have to create an individual running total for each of the different codes or is there some handy function that will do it for me?

tks, mike

 

[synapsevampire]

Tey inserting a cross-tab in the report footer and palce the code as the row and a count as the summary operation.

-k

 

[inncoggnitto]

wow, that was so nice and simple once it was explained.

thanks so much.

i wonder if maybe you could make sense of my other post, unless that would be greedy. is seems like it should be a cross tab kinda thing but i have not used cross-tabs yet. just read about them. here was the initial post, not sure how to put a link in this text box. thanks again.

inncoggnitto (Programmer)5 replies 26 Jul 06 (26 Jul 06)
need report with all the field headers in left column
i have a request for a report to list all the data contained in a table w/150 fields. the data is information about a location. it needs to look something like this

name bobs dry cleaners
addr 123 main st
city here
state there

etc. for all 150 columns. i have tried cross tabs, regular, and anything else it could think of. is there an easy way to do this w/o having to do it one field at a time for all 150 fields?