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
IS THERE N E ONE WHO CAN HELP ME IN THIS??
ITS NOT FOR N E COMMERCIAL PURPOSES. ITS FOR A SKOOL PROJECT
THX IN ADVANCE!
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 * 30
End IfIS THERE N E ONE WHO CAN HELP ME IN THIS??
ITS NOT FOR N E COMMERCIAL PURPOSES. ITS FOR A SKOOL PROJECT
THX IN ADVANCE!
Last edited:
