% field x $$$ field

I am using Access 2003.
I must be having a "Senior Moment" because for some reason and I can not get
a simple formula to work correctly. I have a Sales $$$ field and a
percentage field. My formula multiples the % field with the Sales $$ field to
come up with a discount field. I formated the % field to be percent with 2
dec points. If I put a ".10" in the field, I expect a 10.00% to come up but
it does not - it comes up 0.00%. If I put in a .75 it comes up as 100% as
does 1.0 come up as 100%. What have I not formated correctly? I know I have
done this many time before without any problem. What is my problem today????

aurora

"Aurora" wrote in message
...
I am using Access 2003.
I must be having a "Senior Moment" because for some reason and I can not
get
a simple formula to work correctly. I have a Sales $$$ field and a
percentage field. My formula multiples the % field with the Sales $$ field
to
come up with a discount field. I formated the % field to be percent with
2
dec points. If I put a ".10" in the field, I expect a 10.00% to come up
but
it does not - it comes up 0.00%. If I put in a .75 it comes up as 100% as
does 1.0 come up as 100%. What have I not formated correctly? I know I
have
done this many time before without any problem. What is my problem
today????


"Percent" is a format, not a field type; the field type determines what
type of data the field can hold. My guess is that your field's type is set
to Number/Long Integer ("Long Integer" being represented in the Field Size
property), or one of the other integer types. But these types can only hold
integers; that is, whole number -- no decimal places. You must set it
instead to Single or Double, or some other type that can hold fractional
amounts.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)