Sort Order for Queries changed from 97 - 2003

[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

 

[Allen Browne]

Brent, I have a vague recollection of this problem in recent versions of
Access, and I suspect that it was fixed in a service pack.

If you do not have 4 JET SP8, go to:
http://support.microsoft.com/default.aspx?scid=kb;en-us;829558&Product=acc2002

If that does not solve the problem, please post back. I'm sure you are not
alone with this problem.

 

[Brent_Fanguy]

Put SP8 still having problems, any other ideas?

brent

 

[Allen Browne]

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

 

[Brent_Fanguy]

I have a .mdb file with the two tables and two queries in
it, can i send it to you?

Brent

 

[Allen Browne]

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.