Prev: Sales & Purchase
Next: Combo Box Issue
From: Duane Hookom on 24 May 2010 22:35
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" <Norm(a)discussions.microsoft.com> wrote in message
news:4A98F816-1634-4652-A83F-0946E7843DBF(a)microsoft.com...
> 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
>> > > .
>> > >
From: regina henn on 28 May 2010 14:08

"Norm" <Norm(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:0233F50E-0188-4604-9607-7C6FF0BFD952(a)microsoft.com...
> 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


First  |  Prev  | 
Pages: 1 2
Prev: Sales & Purchase
Next: Combo Box Issue