Query Error

[Nylex]

I have a Database that has all the products that we sell in it
I have an Update query that gets the data from an Accounting Package and
updates my Products Table
There are 1900 products in the system and the update Query updates the
latest cost and the total qty in stock
The cost update works all the time but the total qty makes an error (app 15
products only) if there is 3 in stock it updates the file to read 4 14.25
updates to 15.25 - it is allways 1 more than what is in stock
I have checked the input from the accounting system and the input is correct
Where do I look to find the problem??

 

[Wayne-I-M]

Have you tried just running the calculatiojn in a seperate query and seeing
if that works.

You need to give more information (post the calculation that is going wrong,
etc)

 

[Nylex]

Tks - I now run 2 update querys and I now get the correct answers