I am already using MS Date report.
How can I usr the SQL with a run time valie into this report??
Ex.
Using ...
sSelect = "SELECT TICKETS.TICKET_NO, TICKETS.PU_TIME, CUSTOMER.FIRSTNAME, CUSTOMER.LASTNAME, TICKETS.LAST_TICK, TICKETS.PU_EMPL, SERVICES.SERV_ABBR, TICKETS.PU_DATE, TICKETS.STRIP_TAG, TICKETS.AMOUNT, DETAIL.QUANITY, COLORS.COLOR_DESC, COLORS.PATT_DESC "
sFrom = "FROM TICKETS, CUSTOMER, SERVICES, DETAIL, COLORS, TRANDETL "
sWhere = "WHERE TICKETS.CUST_NO = CUSTOMER.CUST_NO AND TICKETS.CUST_NO = CUSTOMER.CUST_NO AND TICKETS.SERV_CODE = SERVICES.SERV_CODE AND TICKETS.SERV_CODE = SERVICES.SERV_CODE AND TICKETS.TICKET_NO = DETAIL.TICKET_NO AND DETAIL.COLOR_NO = COLORS.COLOR_NO AND DETAIL.COLOR_NO = COLORS.COLOR_NO AND DETAIL.TICKET_NO = TRANDETL.TICKET_NO AND TICKETS.TICKET_NO = TRANDETL.TICKET_NO AND DETAIL.TICKET_NO = TRANDETL.TICKET_NO AND (TICKETS.PU_DATE IS NOT NULL)AND (TICKETS.PU_DATE = #" + txtDate.Text + "#) "
sOther = "ORDER BY TICKETS.TICKET_NO, TICKETS.PU_TIME;"
strSQL = sSelect + sFrom + sWhere + sOther
rsRep.Open strSQL
How can I get the data generated here in the report when I performg rptDailySales.Show ????
Thanks B-)