Date parameter query

[juicybeasty]

I have a relatively large database with lots of sum queries within queries which are used as a data source for reports - I suspect I didn't set it up as efficiently as I could have!

For all the queries that are required to sum the cumulated data for the financial year - which in my company runs from 1st Nov to 31st Oct - i have used the criteria >=#1/11/2003#.

Unfortunately, each year I am required to change all these queries (there are probably about 100 of them).

Is there anyway I could use a parameter query so I could just enter the year each time the report is run?

 

[dcx693]

I think you're looking for a criteria of the form:
>=DateSerial([Enter the year],11,1)
That will prompt the user to enter a year and take all the entries >= Nov 1 with the given year. If you want to do an historical query though, you would want to exclude data from successive years. You'd want to use something like:
Between DateSerial([Enter the year],11,1) And DateSerial([Enter the year]+1,10,31)

 

[juicybeasty]

That's exactly what I was looking for, I'll try it.
Thanks v much.