Counting

[GeirA]

I have this database:





And would like to count how many persons has authorization to each machine.

I'm trying to get something like:

MachineID Authorized
11 2
12 4

I have tried several combination of count and distinct - but has so far only been able to get the total number of authorized on all machines

[pbaldy]

Try

SELECT MachineID, Count(*) AS HowMany
FROM DSO
WHERE Authorized = True
GROUP BY MachineID

[GeirA]

Thanks! That helped me a lot..

[pbaldy]

Happy to help!

[GeirA]

I have run into another "problem".

Is it possible to display MachineName (from another table) instead of MachineID?

[pbaldy]

You should be able to join the two tables together in your query and then group on the name instead of the ID.

[GeirA]

Thank you for guiding me in the right direction!

With this I got what I wanted:

[pbaldy]

Happy to help!