[AccessD] RE: Dynamic Sorting Report

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.


More information about the AccessD mailing list