Do not repeat a particular column value 1

[danwand]

I have the following query results (simplified):

Name. Payment For. Amount.
John Smith Biscuits £20
John Smith Tea Bags £14
Ian Lins Alcohol £10
Lisa Deed Sugar £8
Lisa Deed Cereal £10

I need to create a report based on this query, however i only want someones name displayed once like this:

Name. Payment For. Amount.
John Smith Biscuits £20
Tea Bags £14
Ian Lins Alcohol £10
Lisa Deed Sugar £8
Cereal £10

The example data given is just an example the information i'm working with is a lot more complicated but the basic premise is to create a report that doesn't repeat the name column, yet still displays the results in the same way as above.

I am aware of 'distinct' keyword but as far as i know i can't use it for a single field unless the whole row is unique.
I'm not sure as to wether this is solved in the actual query or on the report.

Any help would be appreciated.

 

[fneily]

In design view of your report, click on the Name textbox(not the label), bring up the property sheet and change the option Hide Duplicates to Yes.

 

[danwand]

Well i didn't think it would be as simple as that...

Fantastic advice thanks

 

[danwand]

damn..

now i have problems with the format of the lines on the report. When i hide the duplicate names i then lose the surrounding text box lines...any suggestions?

 

[PHV]

Please, ask in the Access Reports forum.