Help with Simple Query

[Cevelctq]

I am trying to finish the last step of a query.

I need to figure out how to display 10% of a quote. I already have the quotes and when I try to make the equation like this- Deposit Amount:

*[10%]

When I try to run the query I have to enter a parameter of 10 to get the correct results.

Help! How do I make the right formula to show 10% of each client's quote without having to enter 10 as the parameter each time it is ran?


Thank you so much in advance!

 

[Jon K]

Deposit Amount:

*0.1

 

[jjturner]

Try

*.1

(When you put the multiplier in brackets, it thinks it's a field name or a parameter)

HTH,
John

 

[Cevelctq]

Thank you so much! Wow that was so simple but I was just stumped