I need help making this statement into a code using vbscript.
I need to find the amount from two tables in an access database with the following fields:
Table Name: Base Data
Fields/ Column title: GLAcc#, CompID, store#, Location, Amount, Month of August
Table Name: RENT CHEQUE
Fields/ Column title: store, NRI, MAG, %Rent
FIRST OF ALL I NEED TO OPEN THE TABLE CALLED RENT CHEQUE
AND THEN
SELECT A STORE TO DETERMINE IF A SALE WAS MADE
IF A SALE WAS MADE THEN,
I MUST USE A FORM
WHICH CONTAIN 2 CHECK BOXES CALLED “NRI”, %RENT” SELECT TO DETERMINE IF “NRI” OR “%RENT” WILL BE USED TO CALCULATE THE “RENT”
THEN I MUST SELECT THE AMOUNT OR [SALE AMOUNT] e.g $7943.69 FROM THETABLE BASE DATA
WHICH IS CORRESPONDING TO THE STORE CHOOSEN
AND
IF NRI IS CHECKED MARKED e.g as “yes” IN TABLE RENT CHECK
SELECT THE NRI FIGURE IN THE BASE DATA TABLE CORRESPONDING TO THE STORE e.g.1066.00
AND
{MULTIPLY THE SALE MADE BY 10%}
AND
ADD NRI VALUE e.g. 1066.00 TO {MULTIPLY THE SALE MADE BY 10%}
AND
PRINT OUT THE RESULT
I AM SO MUCH IN NEED OF A SOLUTION RIGHT NOW.
Thank you so much in advance.!