B
balu
DEAR FRIENDS,
I GOT A TABLE [DRIVER] AND TABLE [SECTION] (ROUTE) & ( DISTENCE) ARE THE
FIELDS ROUTE IS FOR EG, UK-INDIA
DISTENCE IS LIKE THIS
UK-0,USA-10,PARIS-20,RUSSIA-30,AFGAN-40,INDIA-50, ONE MORE ROUTE IS
UK-EGYPT-INDIA DISTENCE IS
UK-0,CUBA-10,ISREL-30,EGYPT-40,UAE-10,AFGAN-25,INDIA-30,
NOW (A) OVER A MAIN FORM JOURNEY IS A FIELD WITH SINGLE FIELD TEXT BOX I
WOULD LIKE TO ENTER DISTECE LIKE THIS AS THE DRIVER RUN IS RANDOM EG,
(UK-EGYPT-UK-RUSSIA-INDIA) THE DISTENCE TRAVELLED IS
(0+10+30+40,40+30+10+0,010+20+30+40+50)
(B) HOW TO ENTER DISTENCE TRAVELLED ON THE FORM
(C) HOW TO SUM THE DISTECE IN OUERY
(D) IF DRIVER CROSSES 100 KMS OF JOURNEY AN INCRIMENT OF 10 ./. WILL BE
GIVEN HOW TO USE IF STATEMENT WITH THE QRY
IM VRY NEW TO ACCESS QRY KINDLY HELP
BALU
I GOT A TABLE [DRIVER] AND TABLE [SECTION] (ROUTE) & ( DISTENCE) ARE THE
FIELDS ROUTE IS FOR EG, UK-INDIA
DISTENCE IS LIKE THIS
UK-0,USA-10,PARIS-20,RUSSIA-30,AFGAN-40,INDIA-50, ONE MORE ROUTE IS
UK-EGYPT-INDIA DISTENCE IS
UK-0,CUBA-10,ISREL-30,EGYPT-40,UAE-10,AFGAN-25,INDIA-30,
NOW (A) OVER A MAIN FORM JOURNEY IS A FIELD WITH SINGLE FIELD TEXT BOX I
WOULD LIKE TO ENTER DISTECE LIKE THIS AS THE DRIVER RUN IS RANDOM EG,
(UK-EGYPT-UK-RUSSIA-INDIA) THE DISTENCE TRAVELLED IS
(0+10+30+40,40+30+10+0,010+20+30+40+50)
(B) HOW TO ENTER DISTENCE TRAVELLED ON THE FORM
(C) HOW TO SUM THE DISTECE IN OUERY
(D) IF DRIVER CROSSES 100 KMS OF JOURNEY AN INCRIMENT OF 10 ./. WILL BE
GIVEN HOW TO USE IF STATEMENT WITH THE QRY
IM VRY NEW TO ACCESS QRY KINDLY HELP
BALU