sort problem in a report!!!! urgent

[geo]

a report pulls out data from a query which has data from
serveral tables. this query is ordered by Column
A, then B and then C. when i run this query, all records
can be sorted by the order. But when displayed on the
report, records wouldn't be
sorted by the specified order (although i have OrderByOn
and OrderBy defined)..

any suggestions??????????????/

Thanks.

 

[Les]

Did you go into the sorting/grouping property of the
report? You should be able to set the sort order there
exactly the same as in your query. >-----Original Message-
----

 

[[MVP] S.Clark]

Check the Sorting & Grouping box.

From the main menu choose: View / Sorting & Grouping


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-