I cannot change data type as this is a linked table
Is there any other way?

"Duane Hookom" wrote:

Are you setting this criteria against a true date field? If so, you may need
to add the data type in the Query-Parameters:
[Enter Start Date] Date/Time

--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/...ddbuz/threads?


"Norm" wrote:

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
.