Percent problems

[Tia]

Hi,

I've got a table that is called Price Category. It has the following fields:

Price Category Price Markup
A 10
B 15
C 20

When I change the Price Markup to a percent, the numbers show up with 2
extra zeros, a decimal point and 2 more zeroes. So I get the following


A 1000.00
B 1500.00
C 2000.00

I need the Price_Markup to be in a percent because it is used in a query to
calculate a customers cost. I, also, tried to enter .10 but then a 0 was
displayed.

Any suggestions?????

 

[Jeff Boyce]

Tia

"15" IS 1500%

..15 is 15%

What are the other properties on the field (e.g., decimal places, etc.)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Wayne-I-M]

Hi Tia

This is easy to fix. But can I make a suggestion.
Open a table in design view (any table will do). Add a new field (don't
save the table). Format the new field as a number and then in the properties
box below select field size and press F1. You will get lots of information
about the different number types.

Good luck

 

[Tia]

That is correct when you type "15" "1500" appears.

Data Type is Number
Field Size is Integer
Format is Percent
Decimal Places is 0

I want to have it stored as a percent so that when I use it in my query to
calculate a new total, it uses .15 instead of 15.

 

[Jeff Boyce]

Field size is integer.

Integers are "whole numbers".

Percentages less than 100% are not whole numbers.

It won't matter how you have the field formatted for display if it only
stores whole numbers.

(by the way, if you want 15%, you'll have to enter .15)

Regards

Jeff Boyce
Microsoft Office/Access MVP