Simple Query Question ?

[Swannie]

Hi all, been a while since I've been on here.

Not used access in over two years now, and thrown back into the deep to produce some data.

Problem : - Two tables - Both with key field, but second table one to many relationship.

Table 1 - Key Field XYZ
Table 2 - Key Field XYZ Code Value ABC
Table 2 - Key Field XYZ Code Value BCD

What I want to be able to do is create a table that looks like this

Key Field, Code Value 1, Code Value 2, Code Vlaue 3, etc all on one flat record.

Cheers

Swannie

 

[neileg]

This article shows how to do it in a report. Don't know how you would do this in a table.
http://support.microsoft.com/default.aspx?scid=kb;en-us;141624