From: Norm on
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
From: John Spencer on
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
From: Norm on
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
> .
>
From: Duane Hookom on
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?


"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
> > .
> >
From: Norm on
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/Forums/en-US/addbuz/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
> > > .
> > >
 |  Next  |  Last
Pages: 1 2
Prev: Sales & Purchase
Next: Combo Box Issue