Filter a report by start and end date

A

APThaler

* I am VERY new to MS Access, please forgive me if I do not give the
correct information.*

I have a table with a date column along with other columns with my
necessary information. I have created a Report that displays my
information by month. My problem is that is displays every month that
is in the table. How do I make the report allow me to just look at 1
month at a time.

I think what I need to do is set up some kind of form with a filter
that will let me enter a start and end date that will somehow link
back to my date column in my table and then filter my report for me.
I am completely unsure how to even start this.

Any help will be greatly appreciated.

Thanks
 
S

Steve

Base your report on a query based on your table. Put the following
expression in the criteria of the date field:
Between [Enter Start Date] And [Enter End Date]

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

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

Filter Report by Form 2
Summary Report 2
Filter Report by form 4
Filter Report Date in VBA 1
Filter a Report Using a Form's Filter 3
How do I filter an Access report? 4
Multi-level GROUP BY 6
Start Date + 7 5

Top