Number to Currency problem !

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

I have a form where it converts the amount to currency, i.e. $50.00 to
fifty dollars and no hundreds
The control on the form is named ExpConEng and it converts amount to
currency, this works ok.
The amount field with its control source set to
=[depositsub].[Form]![ExpNetPay] adds up the total price for the amount
(Check Amount). This adds up the total amount from the sub-form which is in
datasheet view named depositsub where in the form footer it adds up the
amount
and its control source is =Sum([Deposit]) which is located on the
datasheet sub-fom (deposit) control
The problem is that the amount field ( =[depositsub].[Form]![ExpNetPay] )
adds up the correct amount, but the currency field (ExpConEng) only shows
one amount instead of the total.i.e. amount ='s $50.00 then the currency
field shows twenty five dollars and no hundreds
This datasheet sub-from allows you to input multiple records (Deposits) and
then the main from shows the total amount in $00.00 and currency
The query that the form is using is named qrydeposits and the syntax for
the amount to currency is:
ExpConEng: ConvertCurrencyToEnglish([Deposit])
Any suggestions?
Hope this all makes sense...
 
Gulf Coast Electric,

It seems to me that ExpConEng should not be in the query. It should be
an unbound control on the form, with its Control source set to...
=ConvertCurrencyToEnglish([depositsub].[Form]![ExpNetPay])
 
Back
Top