SUBFORMS AND CUMLATIVES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Don't know if anyone can help? I have a subform created which looks like
the one below:

TIME RATIO RATE COST
1 0.25 45.21 11.30
1 1 45.21 45.21

I want to add a column to the end of the subform which details the
cumulative of the cost column i.e. Row 1 CUMULATIVE total would be 11.30 and
Row 2 would be 56.51 etc.....

Have not done any cumulative calculations before....

Suggestions/help would be much appreciated,

Thanks

Sarah
 
Hi Sarah

Here's the SQL statement from an actual app that performs the required task.
If required I can send you a database with the example.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Ottawa, Ontario


SELECT Orders.EmployeeID AS EmpAlias, Sum(Orders.Freight) AS SumOfFreight,
Format(DSum("Freight","Orders","[EmployeeID]<=" & [EmpAlias] & ""),"$0,000.00")
AS RunTot
FROM Orders
GROUP BY Orders.EmployeeID;
 
Thanks so much for your help - problem solved!

Sarah

StCyrM said:
Hi Sarah

Here's the SQL statement from an actual app that performs the required task.
If required I can send you a database with the example.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Ottawa, Ontario


SELECT Orders.EmployeeID AS EmpAlias, Sum(Orders.Freight) AS SumOfFreight,
Format(DSum("Freight","Orders","[EmployeeID]<=" & [EmpAlias] & ""),"$0,000.00")
AS RunTot
FROM Orders
GROUP BY Orders.EmployeeID;

Hi,

Don't know if anyone can help? I have a subform created which looks like
the one below:

TIME RATIO RATE COST
1 0.25 45.21 11.30
1 1 45.21 45.21

I want to add a column to the end of the subform which details the
cumulative of the cost column i.e. Row 1 CUMULATIVE total would be 11.30 and
Row 2 would be 56.51 etc.....

Have not done any cumulative calculations before....

Suggestions/help would be much appreciated,

Thanks

Sarah
Click to expand...
Click to expand...
 
Back
Top