Report Calculation

[Only1Abhi]

Hi People.
Just a quick question please.

Tables: tblTransaction
Query: qryTransaction
Report: rptTransaction

I select only a certain records from the query into the report.
there is a field in the report (and the tbl and qry) called Finance.
This has a number data type.

At the report's footer, i want to be able to calculate the sum of the Finance field, BUT for ONLY the transactions that are visible on the report.

I tried creating a textbox and making the Control SOurce:
=Sum([Finance])
but i get an error.

Please help!



Regards,
Abhi

 

[Only1Abhi]

people, don't worry
i had apparently created the textbox in the page footer, not the report footer!

DoH!

Thanks anyway...
And 1 more quick thing please.
In the tbl,qry and report... I have a date of when the Transaction was stored, i.e. a Date field.

Is it possible to view only a certain records by specifying a START date and an END date?

Many thanx!

Regards,
Only1Abhi

 

[WayneRyan]

Only,

Use the Search facility here to look for: BETWEEN

There will be examples.

Wayne