>I have created a report and put in 1 group to summarize per state.
>I put one field in the group as the sequential no. so I will know right away the number of states in my report by looking at the last item. The problem is that field is counting the number of record per state which give me the wrong output on that supposed to be sequential no.
>
>Total no. of record=69
>Proposed printout
>
>Item no State Buyer
>1 California 34
>2 New York 20
>3 Texas 15
>
>
>Actual printout
>34 California 34
>20 New York 20
>15 Texas 15
>
>How can I make it to work as per proposed printout?
>
>Thanks for your help.
>
>Ed
select State, count(*) as Buyer;
from ClientList;
order by Buyer descending
Run your report on this query, and use a report variable for the item number.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)