May sound like a really dumb question, but please remember I am NEW to Access and databases in general....but....is there a way to run a query that will combine multiple records for the same person? I have a table that shows name and number of wins(fig 1) but after the query I would like it to show as in fig 2. Can this be done and if so how? If not then guess I'll have to go continue to use an excel sheet.
Fig 1 Fig 2 John 2 John 4 Bill 4 Bill 4 Bob 2 Bob 3 John 1 Kate 3 John 1 Kate 3 Bob 1
As always, all help, suggestions, advice is appreciated.
Thanks