Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5377 Views
- I also Faced
- E-Mail Answers
Answer Posted / darsh
Hi Imtiyaz,
use divison to devide the number by 10,100 the quotent will
give you the number for the box so for 20536 divide by
10000 you get 2 for 10000 , then when divide 0536 by 1000
will give 0 for 1000, 536 by 100 will give 5 for 100 and so
on..
you need to use the length to deside where to start
deviding otherwise 0 in the bozes of lacks and crosre even
if the number is in thousands.
Hope this helps.
Enjoy
DG
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is an access macro?
Why do you link tables in access?
Can you purchase just microsoft access?
How do I install microsoft access 2013?
What can be done with microsoft access?
What is the maximum size of ms access database?
Does office 365 include access database?
How do I get microsoft access on my computer?
What are the basic features of ms access?
What is field size access?
What is autonumber in ms access?
What are the main features of ms access?
You need to migrate the ms access database tables to oracle. What steps will you take?
The long and short date option in ms access does not show 4 digit years. How would you achieve the mm/dd/yyyy format?
Is microsoft access being phased out?
