Parameter Query - Limit Records to 14 Days

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

Help, I have a parameter query which asks the user to
input a beginning date. As opposed to making the user
enter the last date in a two-week period, I would like to
limit the query to records to only 14 days but I have no
idea how to do this.
 
If you are using the Query Builder, then something along
the following lines should be put into the Criteria for the
date column
Between [Enter Date] And DateAdd("d",14,[Enter Date])

Hope This Helps
Gerald Stanley MCSD
 
Help, I have a parameter query which asks the user to
input a beginning date. As opposed to making the user
enter the last date in a two-week period, I would like to
limit the query to records to only 14 days but I have no
idea how to do this.
Click to expand...

As criteria in the Date column:
Between [Beginning Date] And DateAdd("d",14,[Beginning Date])
 

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

Creating an update query that uses multiple parameters 2
Parameter Query Won't Run 0
Date Query using Forms Parameter 1
Parameter Query 3
Parameter Query: Limit Parameter 7
query help 2
Parameter Query No Results - Needs to Auto Create Record 4
default value in parameter query 2

Back
Top