Hi,
I have a table that is collecting software information installed on uses PCs. Columns are like this:
USERNAME - SOFTWARENAME - VERSION - PRIORITY
The users are entering a priority for each software on their machine; High, Med or Low.
I have no problems creating a query to group all software by SOFTWARE VERSION PRIORITY to get all of the (for example) Low priority software, but how would I add another column in my query that would group all the usernames that prioritized it the same. For example:
MSOFFICE - v10 - Low - Brian, Joe, Ted
Thanks,
I have a table that is collecting software information installed on uses PCs. Columns are like this:
USERNAME - SOFTWARENAME - VERSION - PRIORITY
The users are entering a priority for each software on their machine; High, Med or Low.
I have no problems creating a query to group all software by SOFTWARE VERSION PRIORITY to get all of the (for example) Low priority software, but how would I add another column in my query that would group all the usernames that prioritized it the same. For example:
MSOFFICE - v10 - Low - Brian, Joe, Ted
Thanks,