Sort Order for Queries changed from 97 - 2003

  • Thread starter Thread starter Brent Fanguy
  • Start date Start date
B

Brent Fanguy

Now when I run a query that has a numeric descending sort
order field the negative items show first then the
positive items. i.e. top sales for customers, sort
descending on sales for the year, customers with negative
sales (returns only for the year) now show on the top of
my result set instead of the bottom. so -51,222 is first
then 1,105,155 1,000,111 98,111 ... down to 0. in 97
against the same database it's 1,105,155 1,000,111
98,111 ... down to 0 then -51,222.

both databases have General for the new database sort

TIA
 
Hi Brent.

A bit more digging suggests that the same problem occurred in Access 2002:
http://support.microsoft.com/default.aspx?scid=kb;en-us;325670&Product=acc2002
It should not be occurring in Access 2003 though.

If you are seeing the problem in Access 2003 with JET 4 SP8 installed, could
you provide some more details please:

1. Is the data is stored in Access table, or other linked table from another
database (or MSDE, or ODBC, ...)?

2. What is the Data Type and Size of field, e.g. Number (Decimal), or Number
(Long), or Text (50)? Or is it possibily a calculated query field?

Probably not related:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328019&Product=acc2002
 
I have a .mdb file with the two tables and two queries in
it, can i send it to you?

Brent
 
Brent, before emailing the file, forward a copy of this thread to the email
address below, by way of making contact.

In the email, please verify these 2 issues:
1. Verify that the data is Access tables (not SQL Server, attached Excel,
....)

2. The Field type in table design is Number on the problem field.
 
Back
Top