Crosstab(?) of software installed

[UTMonkey]

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.

PC1, MS Access
PC2, MS Access
PC2, Excel
PC3, MS Access
PC2, Outlook
PC3, Ladyboys of Bangkok screen saver.
PC3, Outlook

I would like to be able to do the following, first -

Produce a query which looks like the following

                                                  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

                                                  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

 

[stopher]

See attached example.

The tick you ask for is a boolean. You can change it to an x if you like or format it as a tick in a report.

hth
Chris

 

[UTMonkey]

It helps very much Chris, Thank you very much!