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])
 
Back
Top