Multiply Values Between Database Field And Query Prompt Follow
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?
1 comments
0

Shotaro Ito
Comment actions
Would it help if you don't 'quote' that - like TABLE.FIELD * ?QueryPrompt .
Please sign in to leave a comment.