C
Craig
Table Structure:
Table: Siblings
SiblingID (PK)
ContactID (FK)
SiblingDOB
LastName
FirstName
SibSex
SibRace
EntryDate
CalculatedAge
Assessment (Is has to be calculated behind the scenes with an If/Then/
Else statement)
AssessmentComplete
Blah1
Blah2
Blah3
What I need to do:
1) I need to calculate their age using SiblingDOB and EntryDate behind
the scenes and store it in CalculatedAge.
2) I need to take the calculate age and create groups and store it in
Assessment. So
a. If calculatedage >=3 & calculatedage <=5 then Assessment = Test 1
b. If calculatedage >=6 & calculatedage <=12 then assessment = Test 2
c. If calculatedage >=13 & calcualtedage <=18 then assessment = Test 3
d. Else = Error
How do I do this in access?
Thanks!
Table: Siblings
SiblingID (PK)
ContactID (FK)
SiblingDOB
LastName
FirstName
SibSex
SibRace
EntryDate
CalculatedAge
Assessment (Is has to be calculated behind the scenes with an If/Then/
Else statement)
AssessmentComplete
Blah1
Blah2
Blah3
What I need to do:
1) I need to calculate their age using SiblingDOB and EntryDate behind
the scenes and store it in CalculatedAge.
2) I need to take the calculate age and create groups and store it in
Assessment. So
a. If calculatedage >=3 & calculatedage <=5 then Assessment = Test 1
b. If calculatedage >=6 & calculatedage <=12 then assessment = Test 2
c. If calculatedage >=13 & calcualtedage <=18 then assessment = Test 3
d. Else = Error
How do I do this in access?
Thanks!