Formating

[dave1234]

I Have some fields to enter percentages which are text boxes and then other fileds (text) to enter fuel ammounts for example 3,405.00 (litres)*69.44 % = 236443.2 and it should be something like 2364.43 another is 882*65.00% and it gives me back 57330 and it should be 573.30 what am I doing wrong .

Have tryed to make them percentage fields for the percentage and text for the numbers and numbers for number fields but they come up with allsorts of funny things

Regards Dave

 

[Mile-O]

what am I doing wrong

You should be multiplying by 0.65 instead of 65

 

[Jabell]

Change your fuel rebate query:

Expr2: [Total]*([Fuel Rebate on Road%]/100)