Concatenating multiple rows in Access 2010

[Pooks_35]

Good afternoon,
I've been searching around and haven't found the exact answer to help me out with my problem. I have a query that has multiple IDs and different information in numerous fields. For example:
ID Field1 Field2 Field3
1 x
1 m
1 b

I need to find a way to concatenate the data so that it shows the information like this:
ID Field1 Field2 Field3
1 x m b

I'm working in Access 2010.

Yes I know this isn't the best way to set up a database, but I'm trying to make fixes to an already existing database that I can't go back and change the way it is set up. I can only find work arounds to accomplish what I need.
Thanks for any assistance.

 

[spikepl]

First clarify what you have and what you want - insert underscores _ or - to show what data goes into what column. Leaving us to guess does not produce much help for you, does it?

 

[Pooks_35]

I was able to figure it out. Thanks anyway.