|
|
|
date: Fri, 15 Aug 2008 10:38:04 -0700,
group: microsoft.public.access.reports
back
Re: Date Ranges
Another thing, is the field a DateTime datatype of text?
Asking a text field for data between 1/1/2008 and 7/31/2008 will also get
you data from 10/12/2007, 11/15/2008, and 12/11/2007.
--
KARL DEWEY
Build a little - Test a little
"Jeff Boyce" wrote:
> Melanie
>
> One of the quirks of working with date/time data is that both date AND time
> may be stored (if the Now() function is used), but only the date might be
> displayed (via formatting). This means you'll have trouble matching a
> "date" because what you are looking in actually has both date and time.
>
> Can you confirm that the underlying data field holds ONLY date values?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Melanie" wrote in message
> news:F5AD3594-BFE7-44E8-ABF4-F1D95DFEC6E1@microsoft.com...
> > Hi Karl:
> >
> > I entered the criteria below in a query I built because I need to do what
> > the original poster needs. When I enter the start and end dates, my query
> > is
> > still giving me records with dates outside of the range I specified. Do
> > you
> > know if that could be some type of formatting error? Please help! Thanks
> > so
> > much!
> >
> > "KARL DEWEY" wrote:
> >
> >> In a query design view grid under the date field put this in the Criteria
> >> row
> >> --
> >> Between [Enter starting date] AND [Enter ending date]
> >>
> >> --
> >> KARL DEWEY
> >> Build a little - Test a little
> >>
> >>
> >> "Steve" wrote:
> >>
> >> > I would like to run a report where the operator selects a starting date
> >> > and a
> >> > ending date, and then have the report only show that information. Can
> >> > anyone
> >> > help with the process I would need to follow to make that happen? Do I
> >> > need
> >> > a query first? If so, what would the criteria be, etc...or can I do it
> >> > in a
> >> > macro, or in some property of the report.
>
>
>
date: Fri, 15 Aug 2008 15:29:11 -0700
author: KARL DEWEY
Re: Date Ranges
Nice catch, Karl! Yes, if the data just LOOKS as if it were dates, ...!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"KARL DEWEY" wrote in message
news:A79DCB14-C40D-4A10-A2DD-E92C1B0F330D@microsoft.com...
> Another thing, is the field a DateTime datatype of text?
>
> Asking a text field for data between 1/1/2008 and 7/31/2008 will also get
> you data from 10/12/2007, 11/15/2008, and 12/11/2007.
>
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Jeff Boyce" wrote:
>
>> Melanie
>>
>> One of the quirks of working with date/time data is that both date AND
>> time
>> may be stored (if the Now() function is used), but only the date might be
>> displayed (via formatting). This means you'll have trouble matching a
>> "date" because what you are looking in actually has both date and time.
>>
>> Can you confirm that the underlying data field holds ONLY date values?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Melanie" wrote in message
>> news:F5AD3594-BFE7-44E8-ABF4-F1D95DFEC6E1@microsoft.com...
>> > Hi Karl:
>> >
>> > I entered the criteria below in a query I built because I need to do
>> > what
>> > the original poster needs. When I enter the start and end dates, my
>> > query
>> > is
>> > still giving me records with dates outside of the range I specified. Do
>> > you
>> > know if that could be some type of formatting error? Please help!
>> > Thanks
>> > so
>> > much!
>> >
>> > "KARL DEWEY" wrote:
>> >
>> >> In a query design view grid under the date field put this in the
>> >> Criteria
>> >> row
>> >> --
>> >> Between [Enter starting date] AND [Enter ending date]
>> >>
>> >> --
>> >> KARL DEWEY
>> >> Build a little - Test a little
>> >>
>> >>
>> >> "Steve" wrote:
>> >>
>> >> > I would like to run a report where the operator selects a starting
>> >> > date
>> >> > and a
>> >> > ending date, and then have the report only show that information.
>> >> > Can
>> >> > anyone
>> >> > help with the process I would need to follow to make that happen?
>> >> > Do I
>> >> > need
>> >> > a query first? If so, what would the criteria be, etc...or can I do
>> >> > it
>> >> > in a
>> >> > macro, or in some property of the report.
>>
>>
>>
date: Fri, 15 Aug 2008 16:24:30 -0700
author: Jeff Boyce
|
|
