MS access Program / module
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
September 14, 2008 4:47 PM
UPDATED:
September 16, 2008 3:22 PM
Answer Wiki:
You could convert the entered number to a text string, and scan it from right to left, putting each number on the desired text box, starting from the units, tens, hundreds, and so on.
Maybe somebody else can help with the string manipulation functions syntax in access.
*********************************************
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
