Elam, Debbie
DElam at jenkens.com
Wed Nov 19 07:41:05 CST 2003
Many hours since I sent the original, so I am re-sending. Debbie -----Original Message----- From: Elam, Debbie Sent: Tuesday, November 18, 2003 3:33 PM To: 'Access Developers discussion and problem solving' Subject: Dynamic Sorting Report I have a report I originally wrote in Access 97 that I have upgraded to XP. This report sorts dynamically based on the values in a form. This works as advertised in 97, but has one quirk in XP. If I try to sort by ActionDueDate first then there is no discernable order to the report. Any other sort works fine for the first sort. This is the only date in the sort by fields. If both the first and second sort are the ActionDueDate, then it behaves as expected. Some additional info: If the first sort is Attorney, then the report is grouped and each attorney is on a new page. If it is different then the breaks are turned off, but presumably in some ways it is still a group though there is no visual indication of this in the report. Out of curiosity I left the breaks on and there are places where new pages are started. The breaks are in the order of the month and first digit of the day. This makes me wonder if this date is being treated as a string for some reason. The sorting breaks down after that first digit of the day though. Debbie - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.