Can you provide the SQL view?
Can you provide the actual data type?
Can you provide some sample values in the field?
Have you checked any help on how to convert a field to a date value?


--
Duane Hookom
MS Access MVP


"Norm" wrote in message
...
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
.