Convert Currency to English

[HeidiE]

Is there a way to get this formula to round up???

=ConvertCurrencytoEnglish([Text1])

Heidi

 

[dhookom]

Do we have any idea where the function came from or what the code looks like?

Are you using a variation of

http://www.mvps.org/access/modules/mdl0001.htm?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[HeidiE]

I'm not sure what the code looks like.

Actually a better question might be, how to round or convert to currency within the query instead of a report.

I have this calculation, Dividend Amount: ([Interest Paid]/29707084.37*10000000),in a query which carries the number out 11 decimal places. Then when I try to convert this number to english in my report the numbers are off by a penny, because this formula =ConvertCurrencytoEnglish([Text1]) stops after 2 decimal places.

 

[dhookom]

Access has a Round() function.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MichaelRed]

see faq181-1740




MichaelRed