Date Range

[dixxy]

Hello,

I would like to know how to limit my report to a specific date range which is from November 1 of last year to October 31 of this year.

This is a date range that i will be using all the time, it represents a fiscal year.



Thanks,

Sylvain

 

[drctx]

put this in the criteria for the date field:
>=#11/1/2002# And <=#10/31/2003#
or if you want to select a date range use this:
>=[Enter Beginning Date (MM/DD/YYYY)] And <=[Enter Ending Date (MM/DD/YYYY)]

 

[dixxy]

Thanks drctx,

Your suggestion work fine!

Now I have an other questions, if I wannt to take this a step further, and I would like to be able to select which fiscal year I want on my report via a text or combo box of a form. How could I go about doing this?


Thanks,

Sylvain