How To Show the total in letters

[O.V.Killer]

Hello All

I Have Invoise Report
In this report I Have The Total Amount
This Total Amount Come Automaticly After I Put the amount & Discount

So What I Need Is when I Put the amount & Discount The Total Amount be shown in two way Numbers & Leters I'm done from the number part now i need i in leters
Example

TOTAL Amount 500
TOTAL Amount Five Houndred

sorry for my english

 

[RuralGuy]

Maybe this link will help.

 

[ansentry]

Have a look at the attached sample database, it will do what you want.
You will just have to make some changes to suit your database.

I have add a table called tblCharges - Query qryCharges and form frmCharges
you will see that they have Amount - Discount = ExtTotal , these are based on your post.

You can make a report from the query qryCharges and it will display what you want.

Good luck with your project .... your English is fine.



PS the Functions in the attached sample are not mine they came from Microsoft excel site.