Hello. I'm a developer who has done object oriented programming but I'm fairly new to SQL and I'm looking for a bit of help with a query.
Essentially, I have a table in MS Access 2007 which contains information about servers. I am attempting to do is get a count of the different types of servers that were put into production by date.
For an example:
||Server Type||Server Date||
Should appear something like:
What I've tried is something along the lines of:
SELECT impl_date AS Server_Date, (SELECT COUNT (type) FROM Tracker
WHERE type = "Virtual") AS Virtual_count, (SELECT COUNT (type) FROM Tracker
WHERE type = 'Physical') AS Physical_count
GROUP BY impl_date;
Which returns the total value of the counts for each date, instead of the counts for that date only.
I wouldn't be surprised if there was a simple thing I was missing as again, I'm not used to SQL, but any help would be greatly appreciated.