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

Similar Threads

Dates In Excel 5
Date Range in Crosstab query 2
Date Function 5
Calendar Date 4
Query to display the difference of period for an employee. 1
Match Date range with two digit Number (year) 4
date query without year 3
Looking up across date ranges in Access 2

Top