Formatting Problem

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All

I have three fields in my form:

[FullCost] - the full cost of a course - this is in currency fomat.
[MonthPrest] - number of installments to pay the full costs.
[MonthPay] - the cost of each installment - fomatted in currency.

When I divide [FullCost] by [MonthPrest] the currency format goes a little
crazy:

$350 / 6 = $058.33

How can I eliminate the first 0 if the value does not reach 100 -
$50.33

Thanks

Jeff
 
This may be an obvious question but is the MonthPay field
formatted for currency? Also, you stated $350 / 6, maybe
it should be $350.00 / 6?
 
Hi Scott

Both assumptions are correct. It is formatted as currency and the sum is
$350.00 / 6.

Should I take off the currency formatting in the table and only add it in
form?

Any advice really welcome

Jeff

scott said:
This may be an obvious question but is the MonthPay field
formatted for currency? Also, you stated $350 / 6, maybe
it should be $350.00 / 6?


-----Original Message-----
Hi All

I have three fields in my form:

[FullCost] - the full cost of a course - this is in currency fomat.
[MonthPrest] - number of installments to pay the full costs.
[MonthPay] - the cost of each installment - fomatted in currency.

When I divide [FullCost] by [MonthPrest] the currency format goes a little
crazy:

$350 / 6 = $058.33

How can I eliminate the first 0 if the value does not reach 100 -
$50.33

Thanks

Jeff


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/04


.
Click to expand...
Click to expand...
 
It's OK, I got the answer with a little playing.
In the textbox's source property type
=Int([CustoTotal]/[Prest])
This takes away the first 0

Jeff

Jeff said:
Hi All

I have three fields in my form:

[FullCost] - the full cost of a course - this is in currency fomat.
[MonthPrest] - number of installments to pay the full costs.
[MonthPay] - the cost of each installment - fomatted in currency.

When I divide [FullCost] by [MonthPrest] the currency format goes a little
crazy:

$350 / 6 = $058.33

How can I eliminate the first 0 if the value does not reach 100 -
$50.33

Thanks

Jeff
Click to expand...
 
Back
Top