T
Thomas Rector
Office XP XP home PIV 1.8 512mb
I have a funny problem, I am using the expression below in a query,
(design view)
Expr2: DatePart("q",[dateofevent])+1
The date format (dateofevent) is short date, ex=10/31/2004.
Criteria should be 1,2,3, 4 for quarter selection,
But this is the results,
1= nothing
2= Jan Feb Mar
3= Apr May Jun
4= Jul Aug Sep
5= Oct Nov Dec
How do I get 1 to = Oct Nov Dec (which is my 1st qtr) ???
Thanks for any direction you can provide !!
Tom Rector
(e-mail address removed)
I have a funny problem, I am using the expression below in a query,
(design view)
Expr2: DatePart("q",[dateofevent])+1
The date format (dateofevent) is short date, ex=10/31/2004.
Criteria should be 1,2,3, 4 for quarter selection,
But this is the results,
1= nothing
2= Jan Feb Mar
3= Apr May Jun
4= Jul Aug Sep
5= Oct Nov Dec
How do I get 1 to = Oct Nov Dec (which is my 1st qtr) ???
Thanks for any direction you can provide !!
Tom Rector
(e-mail address removed)