Sum of first 5

[zachariack]

Hi friends,



How to make a query for adding first 5 record for each id as shown in the picture below

[Micron]

This one looks like the same problem/question for the 3rd thread.

https://www.access-programmers.co.uk...-query.329988/

https://www.accessforums.net/showthr...862#post520862

[ArviLaanemets]

You question can be paraphrased as 'How to make a query for getting the sum of any random 5 records for each id'. To decide which records from all of records with same ID value must be summarized, you need some additional column to decide which ones to summarize. The reason is, that in Access, there is no way to say a record is before or after of any other, without having a field which determines this order.

[mike60smart]

Can you upload a copy of your database?

[madpiet]

I think this is what you're looking for: Microsoft Access tips: Subquery basics (allenbrowne.com)
See "Top N Records per Group"

In T-SQL you can do it the easy way using CROSS APPLY... yeah, but this isn't T-SQL.

Oh, this is a HASSLE. You need a "uniquifier" so that the data engine can choose ONE of the tied records. (If you just query for SELECT TOP 1 ... and you just order by Mark, any records with the same mark value will be lumped together! One of the things I really like about the ROW_NUMBER() function in T-SQL!!!)