Date parameters
in [General]
|
Prev: Sales & Purchase
Next: Combo Box Issue
From: Norm on 24 May 2010 14:34 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 24 May 2010 15:25 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 24 May 2010 16:18 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 24 May 2010 17:13 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 24 May 2010 20:58
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 > > > . > > > |