Inserting Into A Query

[benheaven]

How would i go about inserting this into a query bearing in mind that i need this query inserted in the field Price EX Vat "=[Price EX Vat]*[Qty]" ive tryed making it on a form as a control source but im unable to change the value as it's says there is a control bond

Thanks
Ben

 

[Pat Hartman]

I'm not sure that I understand the question. You can calculate the VAT in the query:

Select *, [Price EX Vat]*[Qty] As [Price EX Vat]
From YourTable;

BTW, using embedded spaces and special characters in field names is poor practice.

 

[benheaven]

used update query and macro

Used an update query and macro to make it work