Update query percentage prompt

[Stu22]

Hi I need to do a update query with prompt to input a percentage.

 

[pr2-eugin]

Hello Stu22, Welcome to AWF

Create an Form to get this going. Or use VBA.

 

[Stu22]

This is what I have done but I get error ProdSellPrice"+"ProdSellPrice: [ProdSellPrice]*[Enter a percentage]

 

[Stu22]

This is the error message after putting this in "ProdSellPrice+ProdSellPrice *[Enter a Percentage]

 

[CJ_London]

ProdSellPrice needs to be in square brackets

 

[Stu22]

tried that still get same error

 

[CJ_London]

crossposted here

http://www.accessforums.net/queries/update-query-percentage-prompt-51388.html

 

[Stu22]

Thanks for doing that

 

[CJ_London]

your error is telling you that you are trying to update one datatype with another - in this case a (presumably) numeric datatype with text

 

[Stu22]

Ok I've open SQL UPDATE tblProduct, tblProduct AS tblProduct_1 SET tblProduct.ProdSellPrice = "ProdSellPrice"+"ProdSellPrice *[Enter a Percentage:]";
Removed tblProduct I now get a prompt box and it updates but prompt box says tblProduct.ProdSellPrice I need the it to say Enter a Percentage

 

[CJ_London]

suggest you copy and paste your actual sql - what you are posting at then moment will not even run

 

[Stu22]

Thanks for your help this is what worked from another form [ProdSellPrice]*(1+([Enter a Percentage]/100))