Query; update query by percent

[Niclasfa]

Hello all,



I have a problem with a query I am supposed to create. So basically I have the table and need to create an update query that prompts for a certain percentage change. I have attached a photo of what I have done so far but keep getting the same error "is not a valid name'

[ranman256]

Remove the CRITERIA 'enter percentage change' AND from FIELD. these are not fields.
Put in the the field you are changing..[PRODSELLPRICE]
in the UPDATE TO put what you are changing it to: [prodsellprice] * [Enter a multiplier]

[Niclasfa]

Remove the CRITERIA 'enter percentage change' AND from FIELD. these are not fields.
Put in the the field you are changing..[PRODSELLPRICE]
in the UPDATE TO put what you are changing it to: [prodsellprice] * [Enter a multiplier]

Thank you for helping. This doesn't however prompt me when opening for a percentage change when I open it. Outlined in an assessment it requires me to create an update query that will prompt for a certain percentage change when opening. Can this be done because I am struggling to find a solution.