Convert numbers to Words

[Tom]

Hi

I am looking for a function which will convert currency to words, eg £450.00
to Four hundred and fifty pounds.

Am using Access 2002

Any assistance would be appreciated

TIA

Tom

 

[Graham Mandeno]

Hi Tom

There is some code here which can easily be tweaked to suit your needs:
http://www.mvps.org/access/modules/mdl0001.htm

 

[Tom]

Many thanks Graham will work on that

Tom

Hi Tom

There is some code here which can easily be tweaked to suit your needs:
http://www.mvps.org/access/modules/mdl0001.htm
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi

I am looking for a function which will convert currency to words, eg
£450.00 to Four hundred and fifty pounds.

Am using Access 2002

Any assistance would be appreciated

TIA

Tom