Sorting report by Quater

[Jason via AccessMonster.com]

I m trying to sort by quaters. I m using a qry as my basis for the report.
the qry sums up fields and provides me with toals by qtr. I can not seem to
get the sort to work in the report for those quaters. I would like them in
chronoloical order i.e. q3 2004, q4 2004, q1 2005, q2 2005. I just seems to
sort by the fist number. Thank You Jason
--
Message posted via http://www.accessmonster.com

[Salad]

Jason via AccessMonster.com wrote:

I m trying to sort by quaters. I m using a qry as my basis for the report.
the qry sums up fields and provides me with toals by qtr. I can not seem to
get the sort to work in the report for those quaters. I would like them in
chronoloical order i.e. q3 2004, q4 2004, q1 2005, q2 2005. I just seems to
sort by the fist number. Thank You Jason

Sort on Year first, then Q1..Q4 field. I'll assume these two fields are
separate. If this is a concatenated field, this is a string and will
never provide the sort you require.