Limit Records in a Parameter Query

D

DD

Sorry about 2nd post. I wanted to give more information:

Query consists of Event and Event Date:

What i have in the query is [enter event date] and as
opposed to filtering by a single date, I want to show 14
days worth of events from the date the user inputs.

Thanks
 
R

Rick

Okay. This is not pretty, but it works.

Put something like this in the criteria...

Between [enter event date] and DateAdd("d",14,Format([enter event
date],"Short Date"))



HTH,

Rick



Sorry about 2nd post. I wanted to give more information:

Query consists of Event and Event Date:

What i have in the query is [enter event date] and as
opposed to filtering by a single date, I want to show 14
days worth of events from the date the user inputs.

Thanks
 
Top