Re: Decimal values...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Adam Machanic (amachanic_at_air-worldwide.nospamallowed.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 10:14:36 -0500

You'll have to use a character data type. If you keep the zero padding like
that, I believe it will still sort properly...

"Kevin Lisboa" <Kevin.Lisboa@onsemi.com> wrote in message
news:163d101c4172f$fe6b1970$a301280a@phx.gbl...
> Using STS 1.0 with SQL Server 2000 in the back end. One
> of the user groups is requesting a numeric field that
> uses multiple decimal values. Much like chapters in an
> old school book:
>
> 1.0
> 1.1
> 1.1.01
> 1.1.02
> 1.1.03
> 1.2
> 1.2.01
>
> And so on. What's the best Data Type value I can select
> in the SQL Server Database to allow this to be entered?
>
> Thanks for the help...
> Kevin

Relevant Pages

  • Re: Currency Datatype Really Good to Use For Non-currency Fields?
    ... floating point types ... of type CURRENCY, plenty of scope for confusion there, I think. ... For a sort to 'fail' the resultset must contain negative values AND the ... The CHARdata type ...
    (microsoft.public.access.tablesdbdesign)
  • Re: sort report by year (weird format)
    ... Marshall Barton wrote: ... in Sorting and Grouping instead of the field name by itself. ... just getting it to sort the way i want it. ... What data type is the "date" field? ...
    (microsoft.public.access.reports)
  • Re: sort report by year (weird format)
    ... just getting it to sort the way i want it. ... Marshall Barton wrote: ... You did not explain the data type of the date field. ... the report's Sorting and Grouping. ...
    (microsoft.public.access.reports)
  • RE: Time Field: Sorts incorrectly
    ... And if I run a query off of this table directly the time range is OK. ... But like I said the field Time on the Master table is set to Text as the Data Type. ... > Once I sort these times in a query or report they sort as: ...
    (microsoft.public.access.tablesdbdesign)
  • RE: How can I make a table stop auto sorting my info?
    ... As Rick has pointed out the data type is clearly text. ... data type to a long integer number then it will sort correctly. ... SELECT Myfield ... is to add a TimeStamp column to the table of date/time data type and ...
    (microsoft.public.access.tablesdbdesign)