How to eliminate duplicate value from displaying in query result

[ichew]

I have a master table that link to a detail table. The query will
return the name column from the Master table as well as other
information from the detail table. The relationship between the master
and detail is one-to-many, so when I link these two tables, the name
from the Master table will be duplicated when the query result
display.

Can I just show the name once for the return result from the Master
table and subsequent rows will have name shown as blank while display
the rest of the info from detail table.

Any help will be very much appreciated.

 

[scubadiver]

"when I link these two tables, the name from the Master table will be
duplicated when the query result display" - that is the whole point of a
query which is simply another way of looking at a table.

It is possible but not worth the hassle because it is too complicated (from
what I saw from the code anyway). The only way you can do it easily is in a
report.

 

[Steve]

There's no point in doing this or worrying about it. When you use this query
as the recordsource for a form or report, the name will only appear once in
a record.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[S.Clark]

Short answer: No.

Long answer: This can be done in a report by setting the Hide Duplicates
property to True for the control, but there is nothing similar in a query.
If you want to force something like this, then:
1. write the data to a temp table.
2. write to another temp table the Min ID per name value.
3. create an extra field in the first table table for the Name.
4. Using the 2nd temp table, update the new field with the Name where the
values match in the two tables.