Display 3+ rows per person in a database to 1 row per person

[Rugbyman]

Hi

First post from new member.

I have a database of 9 people spread over 26 rows. There are 60 columns of data.

One column contains unique identifier for the person, whether their data is recorded on 7 rows or 1 row.

I need MS Access to run a query that will produce 1 row per person - the new table will be 9 rows and 60 columns.

I don't understand the language used in access tutorials (I've been trying all day) and excel won't do this for me (I do understand Excel very well).

Any help for a complete access novice is appreciated and will be acknowledged.

Thanks

Rugbyman

 

[alansidman]

For the 60 columns of data, is this supposed to be summarized in some fashion for each unique person? Your request is a little bit unclear about how you want this data presented except it should be one row. Please clarify.

If it is a summation then you need to run a group by query. Look at this link.

https://www.techonthenet.com/access/functions/numeric/sum.php