create query to return duplicate values on different column

[omegads]

Good day to all, i'm practically new and learning how to use access, what i want to do is the following, i have a table with two fields "ID" and "Username" what it basically does is record how many times the user logged in.



ID | Username |
-------------|-------------|
1 | Robert |
-------------|-------------|
2 | Diana |
-------------|-------------|
3 | Robert |
-------------|-------------|

what i want to do is a query that returns me the records where that a particular user logged in one column

Username | Records |
-------------|-------------|
Robert | 1 3 |
-------------|-------------|
Diana | 2 |

i don't know if it can be done. if we need VBA to do it, no problem because i'm learning that to so i can easily understand code if we need one.

Regards

[Micron]

It can be done in one way or another, but the question is why?
- If your ID is an autonumber PK field it's not really supposed to be used as meaningful data.
- putting multiple values in a field is not a grand idea either, in most cases. Only once in many years of Access have I ever encountered a situation where it was the solution.
- with multiple values in a field comes the hassle of trying to do anything with the group or its elements

what it basically does is record how many times the user logged in.

Not according to what you're showing. That is ID 1 and ID 3 (basically, records 1 and 3), which is meaningless.

Is what you show the real goal and setup or are you disguising the real situation? I ask because this happens a lot in forums.

BTW, ID makes a poor field name as you will find out when you end up with a bunch of them.

[June7]

That requires a VBA function. Review http://allenbrowne.com/func-concat.html

Could just sort the records by Username.