I've got a chart report that lists all the browsers by version. What I want is to combine the different versions so that the X axis is simply
1. Internet Explorer 4721
2. Firefox 275
3. Chrome 74
4. Opera 12
As it stands now, the chart has about 35 entries in the X axis due to all the various versions. Below is the code I'm working with.
Any help is appreciated.
Select Top 1000000 tblSoftwareUni.softwareName As Software,
Count(tblSoftwareUni.softwareName) As Count
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where (tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Mozilla%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Google%')
Group By tblSoftwareUni.softwareName
Having (tblSoftwareUni.softwareName Like '%Windows Internet Explorer%') Or
(tblSoftwareUni.softwareName Like '%Firefox%') Or
(tblSoftwareUni.softwareName Like '%Chrome')
Order By Count Desc