REPORT DESIGN

Question

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....?