Changing Year in Date Range

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?
 
K

KARL DEWEY

Have you considered using this ---
Between CVDate("4/1/"&Format(Date(),"yyyy")) And
CVDate("3/31/"&Format(DateAdd("yyyy",1,Date()),"yyyy"))
 

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

Top