G
geexcess
I have a query that is showing info like this:
Name Thing Date
A A1 MAY
A A2 MAY
A A3 MAY
B B1 JUNE
B B2 JUNE
B B3 JUNE
B B4 JUNE
B B5 JUNE
C C1 JUNE
C C2 JUNE
C C3 JUNE
C C4 JUNE
Now I want to get rid of the duplicates so it looks like this:
Name Thing Date
A A1 MAY
A2
A3
B B1 JUNE
B2
B3
B4
B5
C C1 JUNE
C2
C3
C4
I tried HideDuplicates for the "Date" but it blocks JUNE from being displayed
again in ANY of the records. I'm looking for some code (I think) that says:
If a record has a duplicate "Name" then hide the records "Date" field. I'm
not sure if this would best be done in a query or report. Please help.
Name Thing Date
A A1 MAY
A A2 MAY
A A3 MAY
B B1 JUNE
B B2 JUNE
B B3 JUNE
B B4 JUNE
B B5 JUNE
C C1 JUNE
C C2 JUNE
C C3 JUNE
C C4 JUNE
Now I want to get rid of the duplicates so it looks like this:
Name Thing Date
A A1 MAY
A2
A3
B B1 JUNE
B2
B3
B4
B5
C C1 JUNE
C2
C3
C4
I tried HideDuplicates for the "Date" but it blocks JUNE from being displayed
again in ANY of the records. I'm looking for some code (I think) that says:
If a record has a duplicate "Name" then hide the records "Date" field. I'm
not sure if this would best be done in a query or report. Please help.