Dateadd function

[na via AccessMonster.com]

I am trying to have the user see so many days in advance. The user has to
enter the amount of days she/he wants to see ahead. Can anyone help me with
this?


Right now I have the query set to where it only displays 15 syas from
todays date, however I want that part to change to where the user can
specify the days.

WHERE (((Customer.[Next Svc]) Between Date() And DateAdd("d",15,Date())));

 

[Duane Hookom]

Try:
WHERE (((Customer.[Next Svc]) Between Date() And DateAdd("d",[Enter Number
of Days],Date())));