Update Query confusion

[BJF]

Hi,

I haven't done an update query in quite some time and forgot how to do the following:

Please see the attached snapshot of my query:

The table on the left side (tblSalesOrdersDetails) has the field named 'LabelSaved' which contains numbers only(they are LabelId numbers from the tblStockLabels table) ex. 510, 112, 234, etc.

I need to update/convert the LabelSaved field from tblSalesOrdersDetails to the field StockLabel from tblStockLabels.

I tried joining the two fields but this is obviously wrong as you can see by the error when i click run.

Any help would be appreciated.
Thanks,
BJF

 

[plog]

'LabelSaved' which contains numbers only

Expand on that. Does the field itself have the datatype 'Number'? Or is it a Text field that you are hoping people only put numbers into?

Both fields that you JOIN ON need to be of the same data type.

 

[obeylele]

If [StockLabel] is text and you are trying to update a numeric field [LabelSaved] that wont work.

Why are you trying to do this. If you need to show [LabelSaved] text instead of [LabelSaved] number you can do that with a query.