year and moth wise report with one query in vb6.0

Discussion in 'Visual Basic ( VB )' started by srbatcha, Mar 25, 2010.

  1. srbatcha

    srbatcha New Member

    Aug 31, 2009
    Likes Received:
    Trophy Points:
    I am doing one project using vb6.0 with ms-access. my question is

    How to create ( monthly wise and year wise report in one query) based on below query.

    [ rec.Open "select Sales_Person_ID,Employee_Name,sum(Total_value),division_name,segment_name from segment_trans GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic ]

    because i am using separate query for month wise query and year wise query
    i got very confusing result.

    Please help me

    Thank you


Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice