1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    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