Show only Current Year on Report

  • Thread starter Newf via AccessMonster.com
  • Start date
N

Newf via AccessMonster.com

I was wondering is there a way to show only the current year (YYYY) on a
report???

Thanks in advance

cw
 
J

Jeff C

When I have restrictions like that, either current year or current month, I
modify the query the report is based on to include a new column.

Current Month: Format([mydatefield],"mmmm") OR Current Year:
Format([mydatefield],"yyyy")

Then in the criteria - format(date(),"yyyy") OR format(Date(),"mmmm")
 
Top