Update query percentage prompt

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 28, 2015

• #1

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

 

pr2-eugin

Super Moderator

Local time

Today, 12:31

Joined

Nov 30, 2011

Messages

8,494

• Mar 28, 2015

• #2

Hello Stu22, Welcome to AWF

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

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 28, 2015

• #3

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

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 29, 2015

• #4

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

 

Attachments

• 
  Screen Shot 2015-03-29 at 10.29.41 am.jpg

  97.5 KB · Views: 140

C

CJ_London

Super Moderator

Staff member

Local time

Today, 12:31

Joined

Feb 19, 2013

Messages

17,503

• Mar 29, 2015

• #5

ProdSellPrice needs to be in square brackets

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 29, 2015

• #6

tried that still get same error

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 12:31

Joined

Feb 19, 2013

Messages

17,503

• Mar 29, 2015

• #7

crossposted here

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

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 29, 2015

• #8

Thanks for doing that

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 12:31

Joined

Feb 19, 2013

Messages

17,503

• Mar 29, 2015

• #9

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

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 29, 2015

• #10

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

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 12:31

Joined

Feb 19, 2013

Messages

17,503

• Mar 29, 2015

• #11

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

 

S

Stu22

New member

Local time

Today, 04:31

Joined

Mar 28, 2015

Messages

8

• Mar 31, 2015

• #12

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