Date Range

  • Thread starter Thread starter Ryan Card
  • Start date Start date
R

Ryan Card

I am trying to run a database,and need a date range for my printouts on
Access 2000, but can not figure out how to do it? Thanks so much,God Bless
 
Ryan,

There are quite a few methods for this, but a simple one is
to base your reports on a query that will prompt you for the
dates you would like. Create a query that has all the fields
needed for the report. In the Criteria line of your date
field in the query put something similar to the following...

Between [Enter the starting date] and [Enter the ending
date]

Now change the record source of your report and you will be
prompted for the starting and ending dates and the query and
report should just show that range.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top