Carry Forward / Opening Of Balance

[aamer]

Carry Forward / Opening of balance



I am trying to add Carry Forward / Opening of balance to a report.
I am stuck, what and how to add the formulas to a query or report.
Can someone guide me.

Below is the format of the report and also have attached the sample DB.









SAMPLE DB: Op A00 Op A00.zip

[ranman256]

Try to keep formulas in the query. I hope the balance is in the table, but you can do calculations in a query cell.
Balance: [field1]-[field2]

[aamer]

Try to keep formulas in the query. I hope the balance is in the table, but you can do calculations in a query cell.
Balance: [field1]-[field2]

To achieve this I need to have a Dsum Value. for which I don't know what formula to use in query or report.

[ranman256]

you don't use Dsum in a query (nor Dcount, etc), the query does the summing.

[aamer]

Try to keep formulas in the query. I hope the balance is in the table, but you can do calculations in a query cell.
Balance: [field1]-[field2]

which Field2 is to be subtracted from Field1 Where as the query on the form is:


SELECT DISTINCT [1 Pchase].PurCoId, [1 Pchase].PurCompanyName, Sum([1 Pchase].[Total Amount]) AS [SumOfTotal Amount], [1 Pchase].PurDate, [1 Pchase].PurTransId
FROM [1 Pchase]
GROUP BY [1 Pchase].PurCoId, [1 Pchase].PurCompanyName, [1 Pchase].PurDate, [1 Pchase].PurTransId
HAVING ((([1 Pchase].PurCompanyName)=[Forms]![COPBDTTL].[CboPByco]));