Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Recall Datefield's date + 14 days Criteria 1

Status
Not open for further replies.

mark929

Programmer
Nov 30, 2001
67
0
0
US
I'm trying to set a date field criteria in an Access 2007 query to only display records for a datefield's date + 14 days. It's been awhile and I can't seem to remember how to do this. I've only only found online references for today's date "Date() + 14". I need to return the date field's date + 14 days. The datefield's fieldname is "Selection Made".

I know this is simple, but I'm can't seem to remember. Can someone remind me please?

Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top