Items in same row

[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.

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web"

 

[Dave C]

I took a look at the webpage, but either that's not what
I need or I'm not understanding how to do it. I can
concatenate, but I don't know how if it's the same
column. I can concatenate different columns together,
but not in the same column.

-----Original Message-----
Take a look at

http://www.mvps.org/access/modules/mdl0008.htm at "The
Access

 

[Marc]

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

 

[Van T. Dinh]

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.