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
________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range 3
Date search query 0
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
FIlter Information on Report 1
Simple Date Range Help 2
Excel Highlight date ranges 1
Date Range 3
Access Application via the Web 1

Back
Top