Problem with Percentages

[clark]

Hello:

In an update query I have the following:

(([total meal expense])/([total expenses]))*100

However, this returns 6800.00% in my table. If I delete the *100, I get 100.00% - doesn't make much sense. In my table I have the Meal Expense% field as a number/percentage. Any idea on the proper syntax, or why 6800.00%?

Thank you

 

[RV]

(From the helpfile of Access, look for Notation)

When using the property Percentage, the value is multiplied by 100 and a percentage sign is added. The default value voor the poperty Number of Decimals (DecimalPlaces) is 2.

<In my table I have the Meal Expense% field as a number/percentage>

Why? Just define the Meal Expense field as a number and do whatever you want to calculate elsewhere (for example in your query)

Suc6,

RV

 

[KKilfoil]

1) You should NOT store Meal Expense as a table value. If it can be calculated, then calculate it. Do NOT keep it.

2) In your present setup, you probably have your field defined as number/long, which can only store integers. So a calculation which would be exactly 0.68 gets stored as '1'. When displayed as a percent, this shows as 100%. Chnage your field type to number/single

3) see point number 1