Totals on an interval 1

[markedback]

I am trying to display total (dollat amount) of donations collected by reps in a MS-Access report.

This monthly report needs to show number of calls successful and rejected; expected amount and collected amount.

The report shows the correct number of calls for the month but totals up the dollar amount for all the calls in underlying table and not for the month range entered through a parameter prompt.

I want the report to show the dollar amount for the month range entered when report is run.

I was trying to use the following syntax in the text field that displays the totals >>

For the Expected amount total:
=Sum(IIF([Call_date]="Between [StartDate] And [EndDate]", [Expected_amount],0))

and

For the Collected amount total:
=Sum(IIF([Call_date]="Between [StartDate] And [EndDate]", [Collected_amount],0))

But I keep getting the error that the expression is typed incorrectly or is too complex.

Please advice and suggest a correct syntax.

Thanks in advance.

 

[dhookom]

Try:

=Sum(Abs([Call_date] Between [StartDate] And [EndDate]) * [Expected_amount])

Duane
Hook'D on Access
MS Access MVP

 

[markedback]

Duane,

It worked!

Thanks a lot!