Parameter date equation

G

Guest

In the criteria section of a date record I want it to create a parameter
between two dates. I have input the simple equation:

Between [Enter Start Date] AND [Enter End Date]

How can I get the second field to generate automatically generate 14 days
from the first date entered? I want [Enter End Date] to equal [Enter Start
Date] +14
 
G

Guest

Between [Enter Start Date] And DateAdd("d",15,[Enter Start Date])
Thanks, just figured it out off of an older posting, but I do greatly
appreciate the help.

Van T. Dinh said:
BETWEEN [Enter Start Date]
AND DateAdd("d", 14, [Enter Start Date])

--
HTH
Van T. Dinh
MVP (Access)



dogpigfish said:
In the criteria section of a date record I want it to create a parameter
between two dates. I have input the simple equation:

Between [Enter Start Date] AND [Enter End Date]

How can I get the second field to generate automatically generate 14 days
from the first date entered? I want [Enter End Date] to equal [Enter Start
Date] +14
Click to expand...
Click to expand...
 

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 with DSum 1
Between Dates Criteria 2
query help 2
Export to Excel with Parameter in Filename 1
Parameter Query to filter dates as entered in and if not to show N 4
show criteria data from a query on a report using that query 2
Parameter query issue in Access 2003 6
Parameter Query 8

Top