Limiting the "many" side query results

[Guest]

This should be a simple question I think. When you query tables where a
one-to-many relationship exists, (how) can you prevent the "one" side records
from displaying over and over for each of the "many" side records?

Basically, the query looks just a flat file in Excel with the same
information repeated. Is there a way to clean up the query to eliminate this,
or am I forced to use a form or report?

 

[Allen Browne]

The query is designed to give flat-file type results from relational data.

How are you expecting it to work? Do you expect blanks under the repeating
values from the primary table, as if the values were Null? What if they are
not sorted in that order?

 

[Guest]

While I haven't seen it, I bet that there is a very convoluted way to make it
happen in a query; however, it's probably not worth the effort.

Now reports are a different matter. Make a tabular report out of the query.
While in design view right click on the field with repeating data. Select
Properties and go to the Format tab. Change Hide Duplicates to Yes.