Cumulative Amounts by Month

[o wilson]

Hello,
I have a query that shows starting contract value,
payments from contract and amount remaining. I'd like to
show the value remaing by month, but I don't want March's
deductions incuded in the February report, even if the
February report is run in March.

Am I makng any snse at all here?

Thanks,
Owen Wilson

 

[John Vinson]

Hello,
I have a query that shows starting contract value,
payments from contract and amount remaining. I'd like to
show the value remaing by month, but I don't want March's
deductions incuded in the February report, even if the
February report is run in March.

Am I makng any snse at all here?

Well, yes, but bear in mind that we have no idea how your table stores
the information or what else you want to appear on the report. I would
guess that a DSum() expression calculating the payments up to the end
of the previous month would help:

[balance] - DSum("[Payments]", "[some-table]", "[PaymentDate] < #" &
DateSerial(Year(Date()), Month(Date()), 1) & "#")

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps