Update Query Percentage Calculation

  • Thread starter Thread starter steve c @ matco electric
  • Start date Start date
S

steve c @ matco electric

Good Morning/Afternoon/Evening,

I am using a table that stores information that I would
like to run an update query on periodically to calculate
pecentages from user-entered numbers.

For example, a user inputs "estimated price" and "buyout
cost".

From that information "money saved" and "percentage
saved" are calculated -

Money saved = estimated price - buyout cost (the first of
my two update queries)

Percentage saved = Money Saved / estimated price

When I run these update queries, the SUBTRACTION
operation in the first query runs flawlessly, however,
when the DIVISION operation runs in the second query, the
updated result in the table is always displayed as
either "100%" or "50%" or "0%," the appropriate
percentage never displays, and always rounds itself to 0
or 50 or 100. Any ideas as to what might be causing this
problem? Thanks in advance for your help!
 
Some more information could be helpful
For example, What are the data types of the source and
destination fields.
The exact sql of the query would also be helpful.
Obviously you cannot get a percentage by just dividing
 
Back
Top