Diane,
Make sure you look at the bottom info about the field you have setup as
a number - make sure it is set as single or double, rather than integer
or long integer. Integer fields will always be just the whole number
part, rather than the complete number and decimal values which is what
you are in need of. You would probably, based on the values you are
talking about, want to use single rather than double, since double takes
up LOTS more storage than single.
Ralph
Diane Roeder wrote:
>
> I am setting up a database that includes a field in which I want to store
> data about the length of fiber in inches. When I set up the field in Design
> View I specified that the data should be numeric. Despite the fact that I
> specified that the decimal should be two places, when I enter 3.5 it appears
> as 4. As usual, when I hit F1 for help I have no idea what they're trying
> to tell me. Any suggestions? Thank you.
>
> Diane
============= PCWorks Mailing List =================
Don't see your post? Check our posting guidelines &
make sure you've followed proper posting procedures,
http://pcworkers.com/rules.htm
Contact list owner <[EMAIL PROTECTED]>
Unsubscribing and other changes: http://pcworkers.com
=====================================================
