Thread: Date parameters
View Single Post
  #2  
Old May 24th, 2010, 08:25 PM posted to microsoft.public.access
John Spencer
external usenet poster
  
Posts: 7,815
Default Date parameters
You could use criteria like

Between [Enter Start Date] and DateAdd("d",30,[Enter Start Date])

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Norm wrote:
I want to be able to enter a date and have it pull everthing 30 days in the
future... it is for expiry date warnings