Update Query Not Working

[michael shearer]

Hi,

I have an update query that is supposed to update from a blank cell to
a number with five decimal places.

For some reason, when I run it or view the datasheet, the values do
not display. When I run a select query to view the data that is
supposed to update, I can see it.

There are additional fields in the update query that are all
calculations based on the value that displays as blank. Here is the
SQL for it:

UPDATE CurrencyConversion, RoyaltyReport SET RoyaltyReport.[Currency
Conversion] = CurrencyConversion.[Currency Rate], RoyaltyReport.[USD
Gross Total] = RoyaltyReport.[USD Gross Total]*CurrencyConversion.
[Currency Rate], RoyaltyReport.[Total Sale] = RoyaltyReport.[Total
Sale]*CurrencyConversion.[Currency Rate], RoyaltyReport.USD =
RoyaltyReport.USD*CurrencyConversion.[Currency Rate],
RoyaltyReport.ROYALTY = RoyaltyReport.Royalty*CurrencyConversion.
[Currency Rate], RoyaltyReport.unitprice =
RoyaltyReport.unitprice*CurrencyConversion.[Currency Rate]
WHERE (((RoyaltyReport.SOURCE)=[CurrencyConversion].[Month Paid]));

Any thoughts on this? Thanks for your time.

Kindly,

Michael

 

[Biz Enhancer]

Hi Michael,

It sounds like all the first thing you need to check is the datatype for
the table field . If it is set as an integer is will round the numbers.
However, if you set it a a Decimal in the feildsize then you can set the
precision and scale values. The precision being the total number of
digits that can be stored, the scale being the number of digits to be
stored to the right of the decimal point.

HTH,
Regards,
Nick.

 

[noreply@noreply]

Disposal now it's solace pretty oftentimes a money-sink, and galore of the weapons you can make from doing quests are easier aoc gold[/url:36rn6yd8]to obtain and writer coercive than crafted weapons. So far, nonetheless, my income The Royal of the Rings Online impressions are (http://www.ugamegold.com/age-of-conan-gold/:36rn6yd8)sh.