Date parameters

[Norm]

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

 

[John Spencer]

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]

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!!!

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

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

.

 

[Duane Hookom]

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/Forums/en-US/addbuz/threads?

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!!!

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

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

.

 

[Norm]

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

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/Forums/en-US/addbuz/threads?

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!!!

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
.

 

[Duane Hookom]

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

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

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/Forums/en-US/addbuz/threads?

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!!!

:

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
.

 

[regina henn]

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