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

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.


"Aamer" wrote:

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

Thank You

"KARL DEWEY" wrote:

> 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.
>
>
> "Aamer" wrote:
>
> > 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
> >
> >
> >