ConvertCurrencyToEnglish

[Joshua Beel]

I am having issues getting access to store when using the
ConvertCurrencyToEnglish function. I set the ConvertCurrencyToEnglish
function as the control source for the control on my form, but how do I tell
access to store that in a certain column within my database?

 

[Douglas J. Steele]

Why would you? It would be redundant to store the amount and the English
equivalent of the amount.

Just store the amount: you can recalculate the English equivalent whenever
you need it.

 

[Joshua Beel]

It has to store so that it will mail merge onto a bank draft.

 

[Douglas J. Steele]

No it doesn't.

Create a query that calls the function and use the query for the mail merge
rather than the table.

 

[Joshua Beel]

Thank you that worked perfect...

No it doesn't.

Create a query that calls the function and use the query for the mail merge
rather than the table.