Re: Access Sorting

From: Bob I <birelan@xxxxxxxxx>
Date: Wed, 15 Nov 2006 10:13:49 -0600

10-19 isn't numerical, it is text, and sorting text will put it in that order.

Derek wrote:

Probably a stupid question, but I have an Access Database and a numerical column. I am trying in a query to have that column sorted ascending, but Access puts 10-19 before 2, and 20-29 before 3. How can I change this so it's in the proper order?

Thanks

Prev by Date: Re: English Spell Checker Switched to French!
Next by Date: Re: Anyone install Office 2007 on a drive other than "C"? Have issues with Help?
Previous by thread: Re: Is there a way to set my "Insert Clip Art" default to "Behind tex
Next by thread: Re: Access Sorting
Index(es):
- Date
- Thread

Relevant Pages

RE: Weird Problem with a Subreport
... UNION ALL SELECT 1 As ListID, UNIT, Remarks, Place_Holder FROM ... I tried to add Place Holder to the Union query along with UNIT, ... Ok for the sorting i will try to explain it to you. ... Do you have a text box in the Goup Header? ...
(microsoft.public.access.reports)
RE: Weird Problem with a Subreport
... SELECT 0 AS ListID, UNIT, Remarks, Place_Holder FROM AugustND; ... I tried to add Place Holder to the Union query along with UNIT, ... Ok for the sorting i will try to explain it to you. ... Do you have a text box in the Goup Header? ...
(microsoft.public.access.reports)
RE: Weird Problem with a Subreport
... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
(microsoft.public.access.reports)
RE: Weird Problem with a Subreport
... and used sorting and grouping to sort by the placeholder and all is well!!!! ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
(microsoft.public.access.reports)
RE: Weird Problem with a Subreport
... Now I need to make reports for the lists for all ... a save as for the reports and just change which query they are getting the ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header? ...
(microsoft.public.access.reports)