[MS_AccessPros] Updating table with Age Group entry

 

I have a table called tblStudent:

tblStudent
StudentID PK
LastName
FirstName
DOB
AgeGroupID - FK to tlkpAgeGroup

The tlkpAgeGroup table contains the following records:
AgeGroupID AgeGroupName
1 18 and Under
2 19 - 21
3 22 - 25
4 26 - 30
5 30 - 35
6 36 - 40
7 41 - 49
8 50 and over

What I am trying to do is update the AgeGroupID field in tblStudent with the appropriate number based on the DOB. Any ideas?

Thanks,

Art Lorenzini,
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___