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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query to filter dates as entered in and if not to show N 4
Parameter Query - Limit Records to 14 Days 2
Creating an update query that uses multiple parameters 2
Return multiple records from a single entry. 2
parameter query issue with single date 4
Counts number of entries per day in query 4
Multiple Records - Need Max of one Field and Corresponding of Anot 3
Another most-recent date query 0

Back
Top