Help Manipulating report report

[James A]

My report currently comes out in this format:

[partnumber] [company] [quantity]
172
Modra 2
183
Electra 1
211
RBH 1
323
Zetex 3
Metro 4
Dingo 1


I place the partnumber on a group header.

I would prefer to be able to place all the details all on the same line since most
of the time there is only 1 customer, but then i get this:



[partnumber] [company] [quantity]
172 Modra 2
183 Electra 1
211 RBH 1
323 Zetex 3
323 Metro 4
323 Dingo 1


As you can see the 323 is duplicated serveral times.
I'm pretty sure it just a simple command to remove the duplicates but I seem to
have forgotten it.

Cheers for the help.

 

[Glenn]

In design mode of the report right-click PartNumber field,
select properties and on the format tab set Hide
Duplicates to "Yes".

Rgds,
Glenn