Help with Date() problem

[jjob]

=[Reports]![Results <4 and >14]![Result<4Total]

Hi all

I need a little help with the above, I need to get the last 14 days total results from the [Results<4Total] field.



the result that i should get is 7, but at the monent i get 54 as that is the total for the time the program has been running.

thank you

[June7]

Maybe:

[Results<4Total] BETWEEN Date() - 14 AND Date()

[jjob]

thanks for that,

but that does not work, I get the answer 0