I track the paper flow during the building of a building. The primary filed is the number for the document from 001 sequentially. Another major field is the specification section number these are usually 6 digit numbers. I've been trying to sort a report by the section number but that never works. I have the Access 2010 "the missing manual" but it is not helping. Is it possible to sort reports by a secondary item?
I've read the similar posts. I guess I need to know how to turn off the primary sort which is base on the submittal # and I want to sort on the specification number.