Multiply Values Between Database Field And Query Prompt

Legacy Poster

• July 16, 2015 10:44

I need to multiply the value from database field with the value given by user. I have tried following SQL command without success (Error S1000):

 

TABLE.FIELD * '?QueryPrompt' AS Nameforthefield

 

If I replace '?QueryPrompt' with number, I am able to run the SQL statement and print labels. What am I doing wrong? Is it even possible to use query prompt in SELECT statement?

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • July 22, 2015 07:17

  Would it help if you don't 'quote' that - like TABLE.FIELD * ?QueryPrompt .

  0

Please sign in to leave a comment.