Adding values for a period of time in access database

[Musoke Herbert]

Good Day Friends

Thanks a lot for the Guidance through Questions answered

Well, am working on a Customer Database and in my Developments I would Like to Guide on how to I can Develop a Function that can Enable me Sum up a Particular Customer Deposits for a period of 60 days , which installments are paid for a Good once the Whole amount is Completed the Customer Takes the Good paid for and the Same Customer can pay for the Very Good another time in Particularly installments,

Am using this , but its not Giving Results

=Nz(DSum("Deposit","Payments","Customer ='" & [Customer] & "Datepaid>=#" & Date()-60 & "#""'"),0)


I will be so Gratefull when helped

[isladogs]

If I understand you correctly, get rid of your expression and create an aggregate (totals) query on table Payments.
Group by Customer, filter DatePaid >Date()-60 and Sum the Deposit field. ... or possibly Sum the expression Nz(Deposit,0)

If you need additional fields, group by those as well but only add extra fields if absolutely necessary or your results may not be what you want.

[cactusdata]

A little correction of the where clause will do it:

=Nz(DSum("Deposit","Payments","Customer ='" & [Customer] & "' And Datepaid >= DateAdd('d', -60, Date())"),0)