Re: sorting numerical values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It is sorting as a text field, not as a number field.

Have a look, in Design View, at your table and check if it says Number next
to this field in the DataType column.

Don't panic if it is a text field, you may not be able to simply change it
for a number field, it may threaten you with dataloss, but there are ways of
doing it and we can help you there.

If however, you have intentially set the field as a text field, then, in the
query on which your report is based, add a field which says

MyGrp:Val([Group]) - that will turn your text back into a number.

You can Sort on this field.

If your Group field has been created using a Format formula eg
Format(MyField,"0") then it will be a text field. These fields are for decor
only.

BTW you may need to ditch the field name Group. It is used by VBA and stuff
which has a second purpose in Access may suddenly and inexplicably, cause
you strange problems (data type mismatch when there is no datatype mismatch,
reports which crash on opening or work fine until you copy and paste them
and other things too horrible to mention in polite company).
Switch on the Name Autocorrect Options (which for some inexplicable reason
are switched off by default in Acc2000) and be prepared to spend some very
tedious time going through all your queries and codes.
Evi

Evi





"PowellGirlTN" <PowellGirlTN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:50A05C39-01CE-4C6A-9D4B-98B2C4D26E89@xxxxxxxxxxxxxxxx
I have a field in my table called Group and the groups are numeric values.
I
want the data on my report to display in assending numeric order but it
comes
out like this 1, 10, 11, 12, 2, 23, 3, 4, 5, 6

how can I make it sort like

1, 2 , 3, 4, 5, 6, 10, 11, 12, 23

I really don't want to have to add a zero to make all groups to
characters.




.

Relevant Pages

  • Re: automatic data sorting?
    ... BUT let's switch to your last post in the *newest* thread. ... Please keep all correspondence within the Group, ... I used the macro recorder and set a hot key. ... Notice, you are going to sort based on the values in Colun B, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: NY AG--defender of children?
    ... 3dB almost requires a common preamp before the switch to overcome switch losses but that isn't too expensive. ... I think it's the same with the child p__n problem: nearly everyone wants to protect children from exploitation, and nearly everyone thinks that liking that sort of thing makes you a really twisted, sick individual, and that suppressing it helps to prevent the spread of that sort of sickness. ... It would be possible to prove that no children were victimized in its production, so the prudential consideration goes away, leaving only the fact that child p__n is really, really, morally corrupt in itself. ...
    (sci.electronics.design)
  • NY AG--defender of children?
    ... "Joerg" wrote in message ... 3dB almost requires a common preamp before the switch to overcome switch losses but that isn't too expensive. ... I think it's the same with the child p__n problem: nearly everyone wants to protect children from exploitation, and nearly everyone thinks that liking that sort of thing makes you a really twisted, sick individual, and that suppressing it helps to prevent the spread of that sort of sickness. ...
    (sci.electronics.design)
  • Re: How secure is my nonencrypted Admin2s Documents directory?
    ... I'm concerned that some sort of internet malware could switch off my ... system's standard WinXp firewall and then a badguy could steal various ... Is it possible for an internet hacker who is sophisticated enough switch ...
    (microsoft.public.windowsxp.general)
  • Re: Water pump
    ... |> |> |The red pump light kept going on and off continually as well. ... |> |> Adjusting the pressure switch always cures that sort of problem for me. ... |> give pointers to what can be done to chase down the answer. ...
    (uk.rec.caravanning)