Print Summary of a Field

[chaddiesel]

Hello Everyone,

I have a table that has a field called Contract_Number. I would like to print a list of unique Contract Numbers. Several of the records might have the same contract number. For example:

Part Contract Number
1 111111
2 111111
3 111111
4 222222
5 222222
6 111111
7 333333

I would like a report to print this:

111111
222222
333333

I've tried grouping, but I just get a list of Contract Numbers with a different number of blank spaces between each header. I've also tried to use the Hide Duplicates, but it just has a blank space for where each record would be. The contract numbers will be different every time. I don't need any numerical totals, but it would be okay to have a total next the Contract Number. I really just need a list. Any help would be appreciated.

Thanks,

Chad

 

[RichO]

Are you printing other fields on the report besides the contract number?

You can either base your report on a query with SELECT DISTINCT or create a grouping on the report with a group header. In this header simply display the contract number field and close up the detail section.

If you want to see a count of each contract number, add a field to the group header with =Count(ContractNumber)