Filter a report by start and end date

  • Thread starter Thread starter APThaler
  • Start date Start 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
 
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)
 
Back
Top