need help query

  • Thread starter pansy Peng via AccessMonster.com
  • Start date
P

pansy Peng via AccessMonster.com

I am the beginner of Query. Could you help me with the following question?
I try to extract "date of birth" of students who enrolled from "term" Fall
2000 to Spring 2005. When I connect table "date of birth" with "term "
table. A student who enrolled for six terms shows up six records with the
same " date of birth". Is there any way that I can only keep one record for
each student? Thank you for your help.
 
Top