Formatting numbers
- From: sparks <sparks@xxxxxxxxxxx>
- Date: Mon, 26 Nov 2007 18:03:02 GMT
We have one database that they are constantly reformatting their
inputs.
I asked about the changes and they can never get the same types of
numbers from the people.
some are -.95 and later they might get -.9 while some have been
collected in the past as 19.9 later the same data comes to them as
19.99
At first they were wanting us to format the fields so they could not
input the wrong numbers but now this has become impossible.
I was wondering if we could do something like ###.###
they assured me that no number would be over 80 and no negative
numbers would be less than 60. as well as nothing with more than 3
significant digits.
I tried it and in this format if they type 6.6 they get 6.6 and
assured them that they are not required to fill in like having to type
0.600
before putting this out I wanted to ask am I correct in doing this?
thanks for help this got to be a mess real quick since they are
collecting over 100 values for each person.
.
- Follow-Ups:
- Re: Formatting numbers
- From: Smartin
- Re: Formatting numbers
- Prev by Date: Re: what is the limitation of the query when error 3360(query too complex) appear
- Next by Date: Re: Force Input Question
- Previous by thread: Cannot Open Report unless I change default printer
- Next by thread: Re: Formatting numbers
- Index(es):
Relevant Pages
|
