I HAVE 16 SELECT QUERY ,RECORDS WITH DIFFERENT ITEM ID'S AND ALSO DIFFERENT CUSTOMER ID'S IN DIFFERENT DATES IN A MONTH WHICH IS MAXIMUM OF 30 DAYS....I MEAN 8 ITEMS(TEA,COFFEE,SOFT DRINKS,FAX,GENERATOR,PHOTO COPY,MINERAL WATER,MISCALLANEOUS)..BELOW.EXAMPLE WHICH IS TO BE DISPLAY IN REPORT
TOTALTEAQTY TOTALTEAAMOUNT (IN THE SAME WAY,REMAINING ITEMS SHOULD DISPLAY ON REPORT)
SO WE HAVE 16 SELECT QUERIES BELOW
1.SELECT TOTALTEAQTY
2.SELECT TOTALTEAAMOUNT
IN FRONT END...AM PASSING FROM DATE AS PARAMETER AND TO DATE AS PARAMETER AND ALSO SELECTING CUSTOMER NAME....THEN HOW TO WRITE PROGRAM IN PREVIEW BUTTON....I GOT HERE IN PRVIEW BUTTON CLICK,FROM DATE AND TO DATE AND CUSTOMER ID ...ALL THE PASSONG PARAMETERS OK...MY QUESTION HOW TO WRITE CODE FOR LOOP IN BUTTON,NOT ONLY DATE,BUT ALSO TEAQTY AND TEA AMOUNT LIKE ETC....THEN WE GOES TO INSERT....?