I made a cross tab query. please see the attach file. the sum of category show in textbox in my project. like:
Stationary = 2000.00
Machinery = 5000.00
Salary = 2200.00
here I can write sql command like:
select sum(stationery) from table1
but here I know the category"stationery" so I write it. but the category will be various. that I don't know what. so how will be the sql command here, that show the sum of category.