On Form - Total amount this month

[loo8866]

Hi there -

I have an accounts form which shows a datasheet of the accounts table. I already have a text box which shows the total of the 'amount' field:

=FormatCurrency(Sum([Amount]))

Now, I am trying to do a total 'this month'. Can anyone offer me any help for this?

 

[loo8866]

Will I have to do this in the query?