Sum of the Amounts showing error in report

[wotamelon]

Hi all! this forum is very interactive

I'm making a report that will show the gross earning of the business when keying in which dates you want.

I'm okay in getting the criteria together, just when I try to get the grand total of the 'AMOUNT' (actual field name) then i get an error.

In summary:
I have the labels PAYMENT DATE and AMOUNT in page header, then I have fields PAYMENT DATE and AMOUNT in details.
Then I have label TOTAL and txtbox =Sum(Nz([Amount])) in page footer.

When I preview it, and key in the dates period, the txtbox of the function shows up error.

 

[PNGBill]

Does the report look correct as far as the data in the Detail section?

Why have you got Payment Date and Payment Amount in the Header?

Confirm the Name and Record Source of the Detail Control for Amount.

In the Footer the Unbound text box control should have =Sum([RecordSource])

Correction.. =Sum([ControlSource])