Getting Sums

[Batselot]

Hi there guys, I just joined the forum to ask a question.I am beginner to the access program and I hope I can learn more by looking at more questions.
So my problem here is I created a query with over 20 lines.And at the end of each 4th line I want to see the sum of the 4 lines.I want the same done for the next 4 as well etc.For better demonstration I have put a picture attached.Thanks a lot in advance,
P.S I am sorry if this question is in the wrong section.

[ranman256]

You cannot do this in access queries.
but in a report you can sum the total of a group. (But not random N lines)
You CAN have running sum.

[Batselot]

I tried it with the report but as you have just said,I got the total number.I need the access to calculate 288 for me though.Do you know how that can be done in reports?

[ranman256]

Insert group bands. This allows you to total on a group (say...employee, or client)
the amt field in the Group footer would be: =sum(Amt)

[June7]

Why 4 lines? As Ranman suggests, what data can be used to associate records in groups of 4? Use report Sorting & Grouping design.