Need to use Parameter Date in query for calculation within 10 days 1

[mckenneyj]

The tables will contain record with dates over several years
I want all dates returned that are within 10 days of the date entered

This works:
>#10/14/2004#-10

This does not:
>[Enter Date]-10

I need the user to be prompted for the date to enter

Thanks,
John McKenney
Work Hard... Play Harder

 

[dhookom]

Try
>DateAdd("d",-10,[Enter Date])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.