Total in Report Footer miscalculating

[LARiot]

Hi,

A text box in the details section has the expression:

=Sum([License Fee])*[Quantity]

in the Control Source property. There is a text box in the Report header with the same exact expression but the total is little off. This works fine when every Quantity field is 1 in the report's recordset.

Can anyone explain why this happens?

Thanks

-Neema

 

[dhookom]

I thought you would use
=Sum([License Fee]*[Quantity])
in the report footer.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[LARiot]

It worked. How bizarre, I could've sworn I tried that. Thanks.

-Neema