Need help building a parameter query w/criteria to show specific dates in the future (1 Viewer)

[browninaz]

Hello all,

I would like to know the criteria for a parameter query that displays records for a future date. I have the criteria for displaying records for a specified amount of days, but I would like to make it a parameter so that the user has to enter a specified amount of days in order to run the query.

I have already Between Now() And Now()+7 to run for the coming week, but do not know how to make it a parameter that asks for a specified amount of days.

A simple request for most of you, I'm sure.

Thanks in advance.

 

[Severin]

Between Date() and Date() + [Enter days:]

You have to use Date() and not Now(). From now is 02/12/2012 21:28:00 (where I am!~) but the date is actually 02/12/2012 00:00:00 so you would miss today in the result!~)

 

[browninaz]

Thanks a bunch Severin. That worked like a top!