See my response to your other post in
microsoft.public.frontpage.programming
Re: Format number to count like a human in asp page
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Hi Murray, long time no "speak". I hope Im in the right forum lol.
|
| I dont know if its an issue with the asp or an access database problem. When
| I produce a list of records the reference field (text) is listed as below.
| (sorry been back into the database to check its status, its definitely a text
| field) I need a way to convert the text so it is recognised as a number, and
| then sorted numerically.
|
| kind regards
|
| "Murray" wrote:
|
| > > Sorry I posted this to the wrong group originally.
| >
| > Are you sure you have hit the target this time?
| >
| > --
| > Murray
| > MVP Expression Web
| >
| >
| > | > > Sorry I posted this to the wrong group originally.
| > >
| > > How do I get the DBRW to sort a number field please. Currently the results
| > > list looks like
| > > 1,11,111,2,21,222,3,31,333
| > > I would like it to read like a human
| > > 1.2.3.4...........21,22, etc.
| > > I know ive seen this thread and answer before, but cant find it. Sorry for
| > > asking again, many thanks
| >
| >