B
Brendan Reynolds \(MVP\)
SELECT ProgramName, Count(WorkStationID) AS Workstations FROM YourTable
GROUP BY ProgramName
GROUP BY ProgramName
CQMMAN said:Hello,
I have a table with a list of different programs, and the clients that they
are installed on.
So the conents might be something like this:
Prog1, 34
Prog2, 34
Prog3, 34
Prog1, 35
Prog1, 37
Prog2, 37
The first column is the program name and the second is an ID of the
workstation.
How can I create a query that displays something like this:
Prog1 3
prog2 2
prog3 1
Cheers
CQMMAN