i have two query:
#1. Year wise Report:
rec.Open “select Sales_Person_ID,Employee_Name,sum(Total_value),div ision_name,segment_name from segment_trans where (segment_trans.date >= #” & (fdate.Text) & “# and segment_trans.date<= #" & (tdate.Text) & "# ) GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic #2. Month wise Report: rec1.Open "select Sales_Person_ID,Employee_Name,sum(Total_value),div ision_name,segment_name from segment_trans where (segment_trans.date >= #” & (Text3.Text) & “# and segment_trans.date<= #" & (Text4.Text) & "# ) GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic How to connect this two Queries with in one Query? please help me. Thanks sathik
