Hi All,
Hope you can help, I currently have a table with the following colums
PC, Software Installed
So the data in the table may look like this.
I would like to be able to do the following, first -
Produce a query which looks like the following
And then, which would be really cool for the query to sort by the software that installed on the most PC's - see below
The best I can do with Crosstab is to generate data with the PC names and the software for the rows - no problem, but the problem is a) how to change the data in the crosstab to a "tick" and b) how to sort by most popular software.
Hope you can help, thanks in advance.
Regards
Hope you can help, I currently have a table with the following colums
PC, Software Installed
So the data in the table may look like this.
Code:
PC1, MS Access
PC2, MS Access
PC2, Excel
PC3, MS Access
PC2, Outlook
PC3, Ladyboys of Bangkok screen saver.
PC3, OutlookProduce a query which looks like the following
Code:
PC1 PC2 PC3
Excel [tick]
Outlook [tick] [tick]
Ladyboys of Bangkok screen saver [tick]
MS Access [tick] [tick] [tick]And then, which would be really cool for the query to sort by the software that installed on the most PC's - see below
Code:
PC1 PC2 PC3
MS Access [tick] [tick] [tick]
Outlook [tick] [tick]
Excel [tick]
Ladyboys of Bangkok screen saver [tick]The best I can do with Crosstab is to generate data with the PC names and the software for the rows - no problem, but the problem is a) how to change the data in the crosstab to a "tick" and b) how to sort by most popular software.
Hope you can help, thanks in advance.
Regards
