Date Serial Problem

[Aamer]

I have a querry in which I am using the Date Serial in the querry criteria as
follows

Between DateSerial([Enter Year:],[Enter Month:],1) And DateSerial([Enter
Year:],[Enter Month:]+1,0)

the result i get is for a a perticular month in a year.

What I want is:

1. if i want to get the results between june to november 2009. how can i do
it?
2. If i want to get the restult of 2008 only e.g. from 01 Jan 2008 (or any
year) upto 31 December 2008. This should give result only for 1 year only.
not by months like from june 2008 to june 2009


Please help me fix this querry


Regards
Aamer

 

[KARL DEWEY]

The prompts have to be different like this --
Between DateSerial([Enter Start Year:],[Enter Start Month:],1) And
DateSerial([Enter End Year:],[Enter End Month:]+1,0)

 

[Aamer]

Thank You

The prompts have to be different like this --
Between DateSerial([Enter Start Year:],[Enter Start Month:],1) And
DateSerial([Enter End Year:],[Enter End Month:]+1,0)

--
Build a little, test a little.

I have a querry in which I am using the Date Serial in the querry criteria as
follows

Between DateSerial([Enter Year:],[Enter Month:],1) And DateSerial([Enter
Year:],[Enter Month:]+1,0)

the result i get is for a a perticular month in a year.

What I want is:

1. if i want to get the results between june to november 2009. how can i do
it?
2. If i want to get the restult of 2008 only e.g. from 01 Jan 2008 (or any
year) upto 31 December 2008. This should give result only for 1 year only.
not by months like from june 2008 to june 2009


Please help me fix this querry


Regards
Aamer