G Guest Apr 8, 2004 #1 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?
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 Apr 8, 2004 #2 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?
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?
