hide duplicate fields in related records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geexcess - 20 Aug 2006 04:40 GMT

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.

Reply to this Message

tina - 20 Aug 2006 05:33 GMT

display the query's records in a report, where you can set a control's
HideDuplicates property to Yes, which will give the result you want.

and please, have a realistic expectation of response time in the
newsgroups - this is not a helpline, but a peer-to-peer forum where private
individuals (not Microsoft employees) ask and answer questions about Access
and help each other. once you've posted a question, recommend you wait at
least a day for a response before posting again; certainly 19 minutes is not
realistic.

hth

> I have a query that is showing info like this:
> Name Thing Date
[quoted text clipped - 28 lines]
> 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.

Reply to this Message

geexcess - 20 Aug 2006 08:21 GMT

Sorry, I don't know what you mean about 19 minutes. Is 11:59pm on Saturdays a
deadline of some sort? I wasn't expecting an answer before midnight. There
was no rush. I have obviously upset you and probably others as well. That was
not my intention. I hope you or someone else will take a closer look at my
request. HideDuplicates hides too much.

>display the query's records in a report, where you can set a control's
>HideDuplicates property to Yes, which will give the result you want.
[quoted text clipped - 13 lines]
>> 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.

Reply to this Message

Michel Walsh - 20 Aug 2006 21:38 GMT

hi,

Unless you can easily spot the previous record (accordingly to the full
date_time), you are better in a report where you will group by (in the
report, NOT in the query) on Name, then on Date. The report wizard can do
all the job for you, if you select the one that hide the dup. in the same
group, except that in the end, you will exchange the position (horizontally)
between the Thing column and the Date column.

Hoping it may help,
Vanderghast, Access MVP

>I have a query that is showing info like this:
> Name Thing Date
[quoted text clipped - 31 lines]
> I'm
> not sure if this would best be done in a query or report. Please help.

Reply to this Message

Harry - 22 Aug 2006 19:59 GMT

OK, I solved this issue with a report. The grouping option that Michel
mentioned previously. I grouped the records by mailbox. Then I could hide any
duplicates for each record associated with the mailbox. Exactly what I
wanted. Thank you for your assistance, Michel. I definitely learned a few
things!

> hi,
>
[quoted text clipped - 43 lines]
> > I'm
> > not sure if this would best be done in a query or report. Please help.

Reply to this Message