Hello everybody, my self is Imtiyaz, i made a small database programm for chal

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

Question Posted / sheikh_imtiyaz

2 Answers
4214 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, bu..

Answer / 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

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, bu..

Answer / mangesh deshmane

Dear Imtiyaz,
you just get that value in string variable , which U want to print on challan, and use left/mid/right functions to print the specific integer on required box. It is a very easy a popular method, I used the same.

Thanks!
Mangesh

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More MS Access Interview Questions

What is the use of ms access 2007?

0 Answers

I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

0 Answers

Does windows 10 have microsoft access?

0 Answers

What is lookup wizard access?

0 Answers

How do I install microsoft access 2013?

0 Answers

What is an access macro?

0 Answers

What are the limitations of microsoft access?

0 Answers

Does office 365 include ms access?