1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

    Joined:
    Aug 31, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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

    sathik
    srbatcha_29@yahoo.com
     

Share This Page