need help on SQL query or a schema to display data on the datagrid using MS Access and VS.net 2003
Posted on 2005-05-16
I have a table in MS Access with 3 fields:
Applications (x, y, z…)
Ticket Status (open, closed, outstanding)
Ticket Number (numbers…)
I want to count each status based on application and then display the number in a datagrid using VS.net 2003..
In the datagrid, I have four columns:
Applications OpenTickets ClosedTickets OutstandingTickets
I tried "count" and datareader method to loop through the table but it ididn't work. I need some help on the query or a method to display the data.
thanks a lot.