Grouped query (1 Viewer)

[bbulla]

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,

 

[vbaInet]

In relation to your fields, what are these?

MSOFFICE - v10 - Low - Brian, Joe, Ted

And how did you get Brian, Joe and Ted?

 

[pbaldy]

Is this type of thing what you're after?

http://www.mvps.org/access/modules/mdl0004.htm

 

[vbaInet]

Is this type of thing what you're after?

http://www.mvps.org/access/modules/mdl0004.htm

I was thinking of that but I thought, "hmmm... the positions of the values don't match with the fields".

 

[pbaldy]

I was assuming (guessing?) that there would be 3 records with the first 3 values (MSOFFICE - v10 - Low) in the example, one each for Brian, Joe & Ted. If so that function could produce the desired result.

 

[vbaInet]

Yes it would. I didn't know Dev Ashish had this code. I'm used to giving people the one from Allen Browne.

 

[bbulla]

Hi,

Yes, I've done this sort of thing in VBA code before, but was hoping there was a way I could just do it in a query. This is just a single table....not a 1:M relationship.

And to my knowledge, the order of your columns in a query don't need to match those of the table.

 

[vbaInet]

Hi,

Yes, I've done this sort of thing in VBA code before, but was hoping there was a way I could just do it in a query. This is just a single table....not a 1:M relationship.

It can't be done.

And to my knowledge, the order of your columns in a query don't need to match those of the table.

You posted a question so for our understanding you need to keep the order the same. If they're not the same in your post then we won't all understand what you're conveying to us.