using a percentage in a calculated statistic query

M

Maria

I need to do a query that would give me the deposit amount if each customer had to pay 20% of their total bill. How do I enter this?
 
K

Kevin11

I think that would be round(totalfieldname*0.2,2)

The second argument (2) is how many decimal points the
deposit should have.

Keivn11
-----Original Message-----
I need to do a query that would give me the deposit
Click to expand...
amount if each customer had to pay 20% of their total
bill. How do I enter this?
 
Top