Parameter Query - Limit Records to 14 Days

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.
 
G

Gerald Stanley

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
 
F

fredg

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: Limit Parameter 7
Parameter Query 3
default value in parameter query 2
Parameter Query No Results - Needs to Auto Create Record 4
need to create a parameter query that will show the records betwee 6
Parameter Queries in Crosstab Query 2
Date Query using Forms Parameter 1

Top