ODBC Sorting in Access

Yahoo Archive
1
I have always gotten wacky results when trying to sort in Access via ODBC.
Sorry I cant offer more advice. I gave up and started importing data into
temp tables.
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, September 16, 2003 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Sorting in Access


Here's a strange one for you.

I'm working on upgrading from 5.0 to 6.0. I have a number of Access
programs set up in 5.0 using the old Merant 3.6 ODBC. I'm having to
modify all of them to work with the new Progress SQL 92 ODBC driver.
I changed one of the programs that used the Invoice Header table, and
sorts it by Invoice Amount, largest to smallest. I couldn't believe
my eyes when I saw negative numbers at the top of the list. I've
been playing around with the numbers in a query, trying to make some
sense out of it, trying to get them to sort correctly. If I sort A
to Z, it looks right. Largest Negative Numbers down to smallest
negative numbers, then smallest positive numbers up to largest
positive numbers.

If I sort Z to A, I get the smallest negative numbers up to the
largest negative numbers, followed by the largest positive numbers
down to the smallest positive numbers.

Has anybody seen anything like this? Any ideas what could cause it?
The only difference between versions is the ODBC driver.

I'd appreciate any suggestions.

Thanks,

Brian Stenglein
Clow Stamping Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Here's a strange one for you.

I'm working on upgrading from 5.0 to 6.0. I have a number of Access
programs set up in 5.0 using the old Merant 3.6 ODBC. I'm having to
modify all of them to work with the new Progress SQL 92 ODBC driver.
I changed one of the programs that used the Invoice Header table, and
sorts it by Invoice Amount, largest to smallest. I couldn't believe
my eyes when I saw negative numbers at the top of the list. I've
been playing around with the numbers in a query, trying to make some
sense out of it, trying to get them to sort correctly. If I sort A
to Z, it looks right. Largest Negative Numbers down to smallest
negative numbers, then smallest positive numbers up to largest
positive numbers.

If I sort Z to A, I get the smallest negative numbers up to the
largest negative numbers, followed by the largest positive numbers
down to the smallest positive numbers.

Has anybody seen anything like this? Any ideas what could cause it?
The only difference between versions is the ODBC driver.

I'd appreciate any suggestions.

Thanks,

Brian Stenglein
Clow Stamping Company