Sum and dates question

[Leanne]

I want to do something along these lines in a unbound control on my subform:

Sum([UnitsSold]) Between "01/07/02" AND "30/06/03"

But it doesn't work - probably because it doesn't recognise these as dates.

Is it possible to do it with the right syntax?

Thanks for any advice

 

[EndersG]

Try using the domain aggregate function DSum(expr, domain[, criteria])) on the unbound control and complete place the date range under the applicable criteria parameter