Unwanted Rounding Percentages

[detailman]

I have tried the online tech chat thing with Microsoft. Below is the
conversation. Can anyone out there help??

2:23:02 PM Steve
hello
2:23:09 PM Hockey
Welcome Steve to the Small Business Online Concierge. How may I assist you?
2:23:24 PM Hockey
Steve, could you be more specific to describe your question?
2:23:59 PM Steve
no matter what i do, i can't get the percentage to work correctly
2:24:18 PM Steve
it continues to round up and down to the nearest 100%
2:24:26 PM Steve
in MS Access
2:25:19 PM Hockey
Okay, Steve. Please give me a moment while I do some searches for you and
see if I could locate some relative articles for your reference.
2:25:29 PM Steve
thank you
2:26:39 PM Hockey
By the way, Steve. May I know if you're referring to Access 2007?
2:27:44 PM Steve
yes i am
2:28:14 PM Hockey
Thanks for the information, Steve. I'm doing the searches for you now. One
moment, please.
2:34:14 PM Hockey
I'm still working on it, Steve. Thanks for your patience.
2:34:40 PM Steve
STILL HERE, WAITING
2:39:39 PM Hockey
Steve, I'm afraid that I have exhausted my resources and I feel sorry to
tell that I couldn't locate any articles about your concern. I suppose this
is a performance issue on Access 2007 and I suggest that you may post your
issue on our Office Forum or contact Microsoft technical support directly.
1. Here is the link for Access forum, where you could post your questions
and some professional engineer will provide the solutions for you
http://www.microsoft.com/office/com...mspx?lang=en&cr=US&dg=microsoft.public.access
2. Here is the contact information for our technical support.
http://support.microsoft.com/oas/default.aspx?gprid=11265
2:41:16 PM Steve
ok...i'll try that...thanks for your help
2:41:49 PM Hockey
You're welcome, Steve. Have a nice weekend and please feel free to contact
us again if you have any questions in future. Thank you for using the
Microsoft Small Business Concierge. We are open 24 hours a day, seven days a
week.

 

[Douglas J. Steele]

Percentage is a format, not a data type. The default Number data type is
Long Integer, and Long Integers cannot store any decimals.

Ensure that your field is a data type that can store decimals: Single,
Double or Decimal.

 

[Clifford Bass]

Hi Steve,

Yes. But we need more detail. How are you calculating the
percentages? In a form? In a query? In a report? What is the formula you
are using? What is the data type of the destination field if you are placing
the value into a field?

Clifford Bass

I have tried the online tech chat thing with Microsoft. Below is the
conversation. Can anyone out there help??

[snip]

 

[Jeff Boyce]

Also check out the "currency" data type...

Regards

Jeff Boyce
Microsoft Office/Access MVP