Counting or Grouping Rows

[Guest]

I have inherited a table with information that looks something like this

Name Frui
John Appl
John Orang
John Pea
Jane Appl
Jane Orangl
Dave Grap

I would either like to get to this

Name Fruit FruitN
John Apple
John Orange
John Pear
Jane Apple
Jane Orangle
Dave Grape

Or this:

Name Frui
John Apple, Orange, Pea
Jane Apple, Orang
Dave Grap

Is there a way to do either or both of these simply with queries?

 

[Duane Hookom]

Your second possible solution is demonstrated with a generic concatenate
function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.