Newbie silly questions: Number formatting and calculations

R

rmc

Hi:

I'm designing a website for a client that basically has his catalog in it
(item #, description, price, weight, shipping, ...)

I'm using FrontPage to access this db using ASP. Everything works except
this (which I don't understand why you can't do this)...

I want the price to be a number field, but Access keeps rounding it off. How
do I prevent this from happening. I have the same problem with the shipping
field.

I want to have Access add those two numbers up and give me a total in
another column. I can't see a way to do this.

I can do all this in Excel. Why not in Access?

Thansk in advance for your patience and advice.

Rich
 
R

rmc

Hi Arvin:

Thanks for your reply, but this is not what I asked. I don't want ANY
rounding (I don't even know why it's happening). If an item costs $12.75 I
want Access to display 12.75, not 13.00.

I don't know what a control is. I changed to 4, but that is decimal places.
It still gives me 13.0000, when all I want is 12.75. If shipping is 3.65, I
want a column (field) to add those two numbers together and give me the
result (16.10).

And I can't understand why you can't add the values from two fields
together... just boggles my mind.

Thanks,

Rich
 
K

Ken Snell [MVP]

Sounds as if the Field Size for that field in the table is Long Integer or
Integer. Change it to Currency, Single, or Double.

--

Ken Snell
<MS ACCESS MVP>
 
R

rmc

Currency displays correctly, but it only passes non-0 digits onto FrontPage.
For example, 12.50 displays as 12.5.

Thanks,

Rich
 
R

rmc

Yes... it shows 2 decimal spaces in the datasheet view. BUT, when FrontPage
calls it up, it only shows non-0 digits.
 
K

Ken Snell [MVP]

Then I would think that you need to change a format or display property in
FrontPage application. I don't have experience with FrontPage...but you
could post your question in one of the frontpage newsgroups.
--

Ken Snell
<MS ACCESS MVP>
 
Top