Report Format

[Musa via AccessMonster.com]

I have a report based on a query.

The results are as follow :

ID Name Table 1 ID Table 2 ID Table 3 ID
1 JJ 1 1
1

2

3
2
1

2

3

How do I prevent the display of Table 3 ID from showing after each Table 2 ID
for the same client ?
I've tried all kinds of combinations of Hide duplicates and groupings.. with
no luck. I would like it to only display once. Like below:
ID Name Table 1 ID Table 2 ID Table 3 ID
1 JJ 1 1
1

2

3

2

Maybe some code to prevent after Table 2 ID = 1 ?


Thanks