Changing Year in Date Range

  • Thread starter Thread starter Jomark
  • Start date Start date
J

Jomark

I am using a crosstab query for selecting data for a date range spanning 12
months over two different years using a "Between & And" date range e.g
Between #01/04/07# And #31/03/08#

For the following 12 month period I can manually change the Year numbers in
the above criteria.

my question is: is it possible to change or select the Year number without
having to change it manually in the query design view by say a parameter box?
 
Have you considered using this ---
Between CVDate("4/1/"&Format(Date(),"yyyy")) And
CVDate("3/31/"&Format(DateAdd("yyyy",1,Date()),"yyyy"))
 
Back
Top