Items in same row

  • Thread starter Thread starter Dave C
  • Start date Start date
D

Dave C

I am creating a query and have multiple item numbers
showing up after inserting the word "distinct" in the SQL
statement. I figured out that I am also displaying the
pages that these items show up on and I need it to. For
example, item 311111 shows up on page 11, 12 and 16. So,
in my query results I have the same item in three rows
with the only difference being the page numbers. Is
there any way in a query or a report that I can display
each of those page numbers on the same row so that I am
displaying one row per item?

Thanks,
Dave C.
 
Hi Dave
In your query you need to sort the query by your item and click the funny E
to group on the item. This removes most duplicates.
Marc
 
I am fairly sure Douglas' advice is correct: the article shows how to
concatenate different values (in your case 11, 12 and 16) of the same Field
of different Records that has the same value in another Field (in your case
311111). To clarify this, look at the example and the SQL String in the
article.
 
Back
Top