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