Date Ranges

  • Thread starter Thread starter Steve
  • Start date Start date
S

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.
 
THANKS!

KARL DEWEY said:
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 said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Nice catch, Karl! Yes, if the data just LOOKS as if it were dates, ...!

Regards

Jeff Boyce
Microsoft Office/Access MVP

KARL DEWEY said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top