Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conditional Lookup Table
I am willing to change the nature of how I store the data, but I am uncertain how to proceed. Here are the metrics that I have to store for lookup: Standard Score (calculated from a Raw score based on Age defined normalized data) i.e. A raw score for a 12 year old would not equal the same...- NavinBane
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Conditional Lookup Table
Thank you for the advice lupins46, but I'm not sure if that will work. Maybe I have it set up wrong, but at the moment I have the norms tables set up based on Age. So there is a table CCT5, a table CCT6, CCT7, etc.. I need it to use the input from the age field to tell the program which table...- NavinBane
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Conditional Lookup Table
Thank you. I will try that. I appreciate the quick response. :)- NavinBane
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Conditional Lookup Table
I am writing a database in MS Access that will track and score customer information based on tests that they have taken. These tests are normalized by age category such that if you are age 20 and have a raw score=30 then standard score=69. I would like to have a form field for age which will...- NavinBane
- Thread
- Replies: 7
- Forum: Microsoft: Access Tables and Relationships
