Update Query

[lspelman]

I did an update query and lost all my data in one of my fields. So I have imported the data back into the database and now trying to do another update query to replace the info for all the records in that one field.



I have the following:

UPDATE [Work Details] SET [Work Details].Hours = [Work Details1].[Hours];


and keep getting the message 'to enter parameter value for [Work Details1].

I'm not sure why I get this and what I'm suppose to enter??

Thanks

[khalid]

you should use the WHERE clause also while updating some columns otherwise the whole database will be updated for that column values.

Check it:

UPDATE Products
SET RetailPrice = RetailPrice * 1.04
WHERE CategoryID = 3

This will update only those records WHERE CategoryID = 3

What is the [Work Details1]??? do you have another table with this name in your database? or its an alias of the same table?