L leo25031 New member Local time Today, 05:36 Joined Apr 21, 2009 Messages 3 Jun 24, 2010 #1 Hi, How can I change the format of currency in a table or query for another country like Brazil to US? Brazil 286.363,966 US 286,363.96
Hi, How can I change the format of currency in a table or query for another country like Brazil to US? Brazil 286.363,966 US 286,363.96
J JANR Registered User. Local time Today, 14:36 Joined Jan 21, 2009 Messages 1,623 Jun 25, 2010 #2 Use the format function: ConvertedField: Format([FieldToConvert],"$#,###.00") JR
C CEH Curtis Local time Today, 07:36 Joined Oct 22, 2004 Messages 1,187 Jun 25, 2010 #3 You can call an apple an orange... but it's still an apple...... Don't you first need to insert the calculation to change USD to BRL???
You can call an apple an orange... but it's still an apple...... Don't you first need to insert the calculation to change USD to BRL???
J JANR Registered User. Local time Today, 14:36 Joined Jan 21, 2009 Messages 1,623 Jun 27, 2010 #4 I assume the OP is aware of this fact thats why I called it "FieldToConvert", but for the sake of the argument you could do it whitin the format function. ConvertedField: Format(([LocalCurrency]*[ExchangeRate]), "$#,###.00") JR
I assume the OP is aware of this fact thats why I called it "FieldToConvert", but for the sake of the argument you could do it whitin the format function. ConvertedField: Format(([LocalCurrency]*[ExchangeRate]), "$#,###.00") JR
