I have created a select query to calculate a %age value from another field:
Price: [Contract Price]/100*60
I have then used created a form based on this query. When I run the form, the 'Price' field is automatically updated when I enter the 'Contract Price', however, I now need to save this calculated value into the 'Price' field in the table but can't find any way to do this. Am I using the wrong type of query?
you can try to update Price value with an update query on your table
or to set recordsurce to your table and at the event On Change for [Contract Price]:
Me.Price.Value =((Me.[Contract Price].Value)/100*60)