Joining Matching Records into one

[spow]

Suppose I have the following data that I want to run a Query on:

Name: Age: Size: Gender:
Bill 10
Mary 20
Bill XL
Mary S
Bill M
Mary F

How would I do a query to output the following:
Name: Age: Size: Gender:
Bill 10 XL M
Mary 20 S F

I'm sure it's obvious, but I'm stuck Thanks for any help!!

 

[THoey]

Is this example one table with six records, three for each person? If so, this is going to make things very difficult. It should be one record each with all the values. That is probably what is causing your confusion. "Alcohol is our friend, and it's about time we had more friends over."

Terry M. Hoey

 

[spow]

No, actually this comes from another Query. This is an extremely simplified example of what I'm trying to do. I think I can do this with an INNER JOIN ?

 

[tlbroadbent]

Try this.

Select
Name,
Max(Age) As mAge,
Max(Size) As mSize,
Max(Gender) As mGender
From TheOtherQuery
Group By Name Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.