Query by quarter

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:DatePart("q",[BDOB]) and
the query doesnt work....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER 1
Concatenate Date and Number field for Append Query 0
Current year Quarterly totals 2
basMedian obtaining quarterly results 5
Crosstab, Quarter Sum isn't working 6
Trying to get my report to sort correctly 3
Query Problem 4
Runtime Error 3000 - Reserved error -3087 0

Top