<div>
<div class="content wysiwyg-content">
I have a query where the output look like example 1, but i need it to look like example two. &nbsp;I am using MS Access 2007.<br />
Example 1:<br />
Diamonds &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 17<br />
Diamonds &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 3<br />
Diamonds &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 5<br />
Bracelets &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 15<br />
Bracelets &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 10<br />
Bracelets &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;page 4<br />
<br />
Example 2:<br />
<br />
Diamonds page 17, page 3, page 5<br />
Bracelets page 5, page 10, page 4<br />
<br />
I tried a cross tab query but it didn’t work
</div>
</div>


I have a query where the output look like example 1, but i need it to look like example two.  I am using MS Access 2007.
Example 1:
Diamonds 	page 17
Diamonds	page 3
Diamonds 	page 5
Bracelets	page 15
Bracelets	page 10
Bracelets 	page 4

Example 2:

Diamonds page 17, page 3, page 5
Bracelets page 5, page 10, page 4

I tried a cross tab query but it didn’t work

MS access changes vertical column into rows

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.