Avoid repeating values in GROUP BY field 1

[BarryMurphy]

If I want to use GROUP BY to group records on Field1, how can I get it to show only distinct values in the first column?

The report should look like this:

Field1 Field2 Field3
1 a b
s d
d e
2 w f
s g
3 a e

 

[MichaelRed]

I'm not real clear what (or WHERE) you're trying to do this. In REPORTS you can set "Hide Duplicates" property. MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[BarryMurphy]

Thanks Michael, that's just what I was after.