[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sort Order in Access seems different than DOS ASCII

Posted on 2009-02-12
2
Medium Priority
?
246 Views
Last Modified: 2013-11-29
I have converted data from DOS FoxPro to Access 2002

We have a field in the DOS that I also use in the Access 2002. The field is a sort field, but it looks like the information is not sort as it did in DOS.

What it was: the dash is the one in question.
PROFFITTRAY
PROFFITTRAY-
PROFFITTRAY&
PROFFITTRAY-JONES
PROFFITTRAY&JONES
Now it is: the dash with a name after is not sorting the same as it did in DOS above
PROFFITTRAY
PROFFITTRAY-
PROFFITTRAY&
PROFFITTRAY&JONES
PROFFITTRAY-JONES

0
Comment
Question by:proffittware
2 Comments
 
LVL 28

Accepted Solution

by:
TextReport earned 2000 total points
ID: 23626224
Hi, this is a by design feature of JET v4.0. Please see http://support.microsoft.com/kb/236952/en-us
Cheers, Andrew
0
 

Author Comment

by:proffittware
ID: 23626345
Thanks Andrew.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question