I have prepared program using MS access, How do i get invoive amount in words automatically from figures ?

Answer 1

write a program which will read the number as units,10's,100';s,1000's,10000's,100000's,1000000's,100000000's etc and store appropriate in english. refer it and print eg.

123 to print as one hundered and twenty three

3 ---> store as three in a unit table (3 is in unit, so read as three)
2 ----> store as twenty in a ten table (2 is in 10, so read as twenty)
1 ----> store as one hundred in hundred table (1 is in 100, so read as hundred)

then concantenate from the left
i.e. one hundered twenty three

add only in the end

write a program. use brain to write the program. there are so many ways, so many logic. never post this type of question.

each person's logic vary. may be there will be very easy way of doing it. and this program is very old. this may have been written by innumerable number of programmers.

bye

Answer 2

you will have to create a table that parses the numeric amounts and references a table of words to create character strings that will display the amount in words or vice versa if the amounts are originally entered in word form. The best way is to require the fields to be entered in the format you would prefer them to be in.

This sounds like a check writing program.