Monthly and Yearly Report

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I need to create a report that will print all records for
the current year. I have a field called moveindate. I
would like to print all records where the moveindate are
within this year. How can I easily do this?
Also, I need to be able to produce a report for all
events for the past month.

I am not sure how to even begin with this.

Thank you
 
I need to create a report that will print all records for
the current year. I have a field called moveindate. I
would like to print all records where the moveindate are
within this year. How can I easily do this?
Also, I need to be able to produce a report for all
events for the past month.

I am not sure how to even begin with this.

Thank you
Click to expand...

To restrict records to the current year, base the report on a query.
As Query criteria:
Where Year([MoveInDate]) = Year(Date())

To restrict records to just those of the past month:

Where Format([MoveInDate],"mm/yyyy") =
Format(DateSerial(Year(Date()),Month(Date()),0),"mm/yyyy")
 
Back
Top