By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

How do you Multiple a Sold field by a Percentage in a query?

anoble1
100+
P: 223
I am creating a query. I have a table that shows sold Amount I would like to multiply it by 1.5% in the query. How do i do that in a field? I tried
Expand|Select|Wrap|Line Numbers
  1. Total Bonus: 1.5%*[Sold$]
in the Field: but didn't work. I suspect that there is a way but not that way.
Jan 7 '19 #1

✓ answered by Rabbit

0.015 is how you express 1.5%

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,335
0.015 is how you express 1.5%
Jan 7 '19 #2

anoble1
100+
P: 223
Good grief..... That is it
Jan 8 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.