K
KyleL
hi all --
i have a field in a table called DOB and i want to sort it by quarter
so under DOB i have Year(Now()) and then i have another field called
DatePart("q",[DOB]) in the query and under criteria i have 1 [1st quarter].
i know this method would work, except every time i tab, or click out of the
'DatePart("q",[BDOB])' field, it changes to Expr 1
atePart("q",[BDOB]) and
the query doesnt work....
i have a field in a table called DOB and i want to sort it by quarter
so under DOB i have Year(Now()) and then i have another field called
DatePart("q",[DOB]) in the query and under criteria i have 1 [1st quarter].
i know this method would work, except every time i tab, or click out of the
'DatePart("q",[BDOB])' field, it changes to Expr 1
atePart("q",[BDOB]) andthe query doesnt work....