Hi Katy, You want to sort on the sortnumber field rather than the objectnumber field. Jeri ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Katy Rawdon-Faucett Sent: Friday, January 19, 2007 3:26 PM To: [log in to unmask] Subject: Crystal Reports question Hi all, I have a Crystal Reports question regarding the sort-order for reports sorted by object number. CR seems to sort in "computer speak," i.e. 10 comes after 1, 20 comes after 2, etc. Is there any way to get around this, so that a report can be sorted by real number order? Please contact me off-list if you would prefer. Thanks, Katy ____________________ Katy Rawdon-Faucett Archivist and Librarian The Barnes Foundation 300 North Latch's Lane Merion, PA 19066-1759 Ph: (610) 667-0290 ext. 1048 Fax: (610) 664-4026 [log in to unmask] <blocked::mailto:[log in to unmask]> www.barnesfoundation.org/archives.html