Date Range

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
 
G

Gary Miller

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
________________________
 

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

Word VBA Copy Heading and Content 4
Need Help with a VBA subroutine 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Countdown macro - display settings 2
Display weeks from a Milestone 0
Append Crosstab Query to Existing Table 0
Happy Thanksgiving Everyone 5
How to Select Multiple Emails using Surface Pen 0

Top