update query returns blank cells

[b_c]

hello all...

...i have an update query that seems sometimes to return a "blank" cell as the result.

any idea what would be causing this?


(if you need more info, just let me know)



cheers,

b_c

 

[Galaxiom]

That is not much to go on.
Generally it would be because your query updated the cell to a null value because that was the result of the expression in the query.

 

[b_c]

yeah, apologies for the little info, i was out the door to dinner and just wanted to post something so i didn't forget.


anyway, the update query actually calls another query that has a calculation. the called query takes a value from a form and subtracts that value from a RunQty to equal a NewRun.

the update query then updates RunQty to equal NewRun.

probably still confusing, eh?


b_c

 

[b_c]

yeah, apologies for the little info, i was out the door to dinner and just wanted to post something so i didn't forget.


anyway, the update query actually calls another query that has a calculation. the called query takes a value from a form and subtracts that value from a RunQty to equal a NewRun.

the update query then updates RunQty to equal NewRun.

probably still confusing, eh?


b_c