Update Query returning zero for a calculated 'update to'

[iamrdbrown]

First thing: I inherited a database created by a no-longer-works-here
person. It has been a nightmare just trying to figure out WHAT this guy was
trying to do, much less fix it since I am not very good with Access myself.
But, that is neither here nor there.

I have a Update query that is not calculating correctly. I have 2 tables
that have 1 field in each that are multiplied together to provide a final
value. The setup is as follows:

table_533_Staffing
SKU is field one (value is a lookup to ResourceTable)
AttainedQty is field two
1000Needed is field three

table_533_ResourceReport (this table changes frequently and is imported when
changes are implemented)
SKU is field one
1000MainLineAssy is field two.

Update Query pulls from the 2 tables above and the update to calculation
looks like this:
[t_533_ResourceReport]![533_1000MainLineAssy]*[533_Staffing]![AttainedQty]

I have put a value in both of the fields used in the calculation
[t_533_ResourceReport]![533_1000MainLineAssy] is a value that is
imported from a text file into access 2003. Current value = 26

[533_Staffing]![AttainedQty] = 10\

I should be updating the 533_Staffing field '1000' with a calculated 26*10,
but I get a zero for the result... I know it has to be something fairly
simple, but it sure has me going in circles. Any help would be greatly
appreciated.

Thanks,
R Brown

 

[iamrdbrown]

Hey, I finally figured out - preview doesn't work for update queries... you
have to actually run them to see the values that are being calculated...
sorry for the unnecessary post.

R Brown