Limit Records in a Parameter Query

  • Thread starter Thread starter DD
  • Start date Start date
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
 
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
 
Back
Top