beginners problem with decimal point display

S

stars

One of the fields in my database I want to display 1
decimal place, even if it is .0. But depsite trying
various diffent options for the data type I find that .1
to.9 are displayed but when it is .0 the .0 is not
displayed. I know this is a simple question but plese help.
Also, I would like to learn more about using Access, can
anyone recommend a good book or tell me how they learnt?
(I have done CLAIT+ and ECDL but they are extremely basic)
 
S

stars

Thanks for that help - it is working fine now. Can you
recommend a good book to help with Access?
 
G

Guest

-----Original Message-----
One of the fields in my database I want to display 1
decimal place, even if it is .0. But depsite trying
various diffent options for the data type I find that .1
to.9 are displayed but when it is .0 the .0 is not
displayed. I know this is a simple question but plese help.
Also, I would like to learn more about using Access, can
anyone recommend a good book or tell me how they learnt?
(I have done CLAIT+ and ECDL but they are extremely basic)
.
I would reccommend the book Microsoft Office 2000, it
Click to expand...
teaches you all the basics using databases. It will also
teach you the basics when using excel and word as well. I
found the book very useful and you can purchase it at any
book store.
 
J

Janet Robison

-----Original Message-----
One of the fields in my database I want to display 1
decimal place, even if it is .0. But depsite trying
various diffent options for the data type I find that .1
to.9 are displayed but when it is .0 the .0 is not
displayed. I know this is a simple question but plese help.
Also, I would like to learn more about using Access, can
anyone recommend a good book or tell me how they learnt?
(I have done CLAIT+ and ECDL but they are extremely basic)
.
I would recommend purchasing the book microsoft 2000, it
Click to expand...
will give you the basic information you need when using
databases. It also gives you help with Microsoft word and
excel. I found this book very useful and is worth
purchasing.

Janet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tiny discrepancies in fixed-point numbers 3
Display fixed decimal place in Access forms 3
Decimal points data not displaying as expected 2
Decimal displays 1, 2, or None 2
Cell displays #'s incorrectly 3
Displaying digits after the decimal point 5
NumberFormat 1
Display of numerical value with decimals in a text box 5

Top