Skip to Content
0
Former Member
Mar 01, 2009 at 05:09 AM

Change table direction

46 Views

Hello everyone

I have a table like below,

Stu#,Parent,Year of Birth

1, Father, 1949

1, Mother, 1954

2, Father, 1949

2, Mother, 1956

Parent is either Father or Monther.

How could I make the report like this?

Stu#, Father Year of Birth, Mother Year of Birth

1, 1949, 1954

2, 1949, 1956

Have been thinking of the solution for the whole day, can't seem find a way. I wonder if it's possible at all. The wrost thing is I have to make a selection of the records either whose Father Year of Birth or whose Mother Year of Birth fall in b/w 1950 and 1955 too. So I should get a record like below eventually,

Stu#, Father Year of Birth, Mother Year of Birth

1, 1949, 1954

Any help/thoughts is appreciated!

Rebecca