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