How to query in access

[Stalker]

where
SIMON 44322
SIMON 12345
SIMON 34857
JERRY 74355
JERRY 12346

to
SIMON 44322 12345 34857
JERRY 74355 12346

 

[kamper]

If such a thing is possible I think you'll need to look at "group by" and some sort of concatenation function. sql queries aren't really meant to produce results like that. You might want to consider doing it manually in your application.