Sabtu, 09 Mei 2020

[MSAccessProfessionals] Need help with an update query

I have a table with lots of fields. The two fields I am concerned with now are QTH and State. QTH is a long text field, State is a short text field.

Some records in the table have State set to 1000. For those records, I want to use an update query to set the State field equal to the QTH field.

The query to select the State=1000 records is easy to do. But I'm not well versed in the use of update queries. After I push the button to convert the select query to an update query, what goes in what cell in the query grid to set the State field to the value of the QTH field?

Thanks.

Steve

Tidak ada komentar:

Posting Komentar