Access

I have a table I want to combine records on:
Name Number Letter
John 1 A
John 2 B
John 3 C

Need to query to make a new table to look like this:

Name Number Letter
John 1,2,3 a,b,c

Any help would beappreciated. Current code is not efficient. Current code consists of deleting the new table each time and re-creating.