Thread: Date parameters
View Single Post
  #3  
Old May 24th, 2010, 09:18 PM posted to microsoft.public.access
Norm
external usenet poster
 
Posts: 149
Default Date parameters

Thanks John
I tried this and when I enter the start date the too complex box pops up
Is there something I missed or forgot to do, I entered the statement below
in the criteria box
Cheers!!!

"John Spencer" wrote:

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

.