Date Ranges

[Steve]

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.

 

[KARL DEWEY]

In a query design view grid under the date field put this in the Criteria row

 

[Steve]

THANKS!

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

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.

 

[Melanie]

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!

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

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.

 

[Jeff Boyce]

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

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!

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

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.

 

[KARL DEWEY]

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

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

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!

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


:

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.

 

[Jeff Boyce]

Nice catch, Karl! Yes, if the data just LOOKS as if it were dates, ...!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

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

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!

:

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


:

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.