Accumulative sum plus another calculation.

[sberti]

I need help to know if this is possible and welcome any thoughts:

Here is a simplified version of my query:

Date	Group	Kg	Cy
31-Jan	1	100	$100
31-Jan	2	200	$200
28-Feb	1	100	$100
28-Feb	2	200	$200

My query has over 400 records with 21 Groups and of course varying Kg and Cy (currency) numbers.

I want to use that query to make something like this:

Date	Group	Kg	Cy	Accum. Cy	Cy/Kg
31-Jan	1	100	$100	$100	$1.00
28-Feb	1	100	$100	$200	$2.00
31-Jan	2	200	$200	$200	$1.00
28-Feb	2	200	$200	$400	$2.00

So, I want to Accumulate the Cy (monthly) by Group in one field and then divide that Accum. Cy by the Kg in another field.

I'm having trouble just getting a single accumulating total Cy, never mind accumulating totals by Group, plus the extra calculation for Cy/Kg.

Although, if I could get the Accum. Cy totals by Group, the final calculation (Cy/Kg) shouldn't be an issue.

I've been trying different solutions and I'm starting to think it can't be done in Access.
Any suggestions?


Thanks.

[June7]

I would do this in a report using its Grouping & Sorting with aggregate calcs functionality.

[sberti]

I would do this in a report using its Grouping & Sorting with aggregate calcs functionality.

Thanks for your suggestion.
The problem is that this is not the final result I need for my report.
The data in my previous post is for Operating Expenses. Each month I need to sum ALL the Operating Expenses for a Group from the StartDate (accumulating) and divide that by the KG to get an ExpenseCy/Kg field.
But I have another set of data (queries) which are Feed Costs. These costs are individual Monthly amounts that DO NOT sum in an accumulative way. This data produces a FeedCy/Kg field.
For my Report, I need to add the the 'ExpenseCy/Kg' to the 'FeedCy/Kg' in the same record to get TotalMonthlyCosts/Kg per Group.
I've made a couple of databases that have been useful. Because of them, I've been given this new project. So I'm not completely new to Access, but have not written SQL or VBA. I've just used queries, macros, reports... the regular Access stuff.
This is more complicated than anything I've tried to do before. Feeling a bit like I'm in over my head. I'm thinking I need to get familiar with SQL & VBA??? Could I do it with either of them?

[June7]

I am sure could be done. Might require a sequence of queries to get there and if query method too complicated or just not practical VBA with temp table is an option. I have gone both routes.