Reply to thread

Message: <blockquote data-quote="ahamednishadh" data-source="post: 1147110" data-attributes="member: 4368">GUYS I NEED A SMALL HELP IN MS ACCESS.ITS LYK DIS. ITS LYK A CAR PARK TICKET SYSTEM. I HAVE DA ARRIVAL TIME AND DA EXIT TIME. AND THEN THERE IS ANOTHER FIELD FOR DA NUMBER OF HRS PARKED WHICH COME BY DEDUCTING DA ARRIVAL TIME FRM DA EXIT TIME. NOW DA NEXT STEP IS DAT I WANT TO CALCULATE DA PRICE.THAT IS I WANT TO GET DA TOTAL PRICE FOR DA NUMBER OF HRS PARKED WEN A BUTTON IS CLICKED(IM DOING THIS IN A ACCESS FORM BY DA WAY). I TRIED DA FOLLOWING VB CODE FOR DA BUTTON BUT IT GIVES DA RESULT IN A NUMBER WITH AROUND 10 DECIMALS. THEN I CHANGED DA FIELD TYPE OF DA PRICE FIELD TO CURRENCY AND THEN IT GIVES DA ANSWER IN DOLLORS AND ALSO ITS NOT WORKING PROPERLY.DA CODE[CODE]Private Sub Command21_Click()hrsParked = Format(DEP_TIME - ENTRY_TIME, "HH:MM:SS")If hrsParked < "01:00:00" Then    TOTAL = "Rs.30.00"Else    TOTAL = hrsParked * 30End If[/CODE]IS THERE N E ONE WHO CAN HELP ME IN THIS??ITS NOT FOR N E COMMERCIAL PURPOSES. ITS FOR A SKOOL PROJECT<img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> THX IN ADVANCE!</blockquote>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom