Calculate total thru date value

[eugz]

Hi All.
I try to generate a report which calculate subtotal for patient AMOUNT for current year and total for whole period from first visit to current date. The result of subtotal =Sum(IIf(Year(Date()=[VisitYr]),[Amount])) is the same like total. What is a correct way?
Thanks.

 

[ScottGem]

Use a DSum

 

[eugz]

If I will use DSUM it gives me total for the whole table. Do you have other decision?
Thanks for replay.

 

[ScottGem]

You can use criteria in a DSUM to filter for specific records.

 

[Rich]

=Sum(IIf(Year([VisitYr])=Year(Date(),[Amount],0))