L
linusb212 via AccessMonster.com
I have a person table that is the parent table.
I have a child table that has a date, a series of yes/no fields, and a risk
category that is a calculated field based on certain combinations of the y/n
fields.
The y/n fields will be logged monthly by date with some interest in the
historical data. I want to transfer the risk category that is associated
with the most recent date to a query of the main data set.
Example, My main form and report will be laid out similarly:
NAME SSN DEMOGRAPHIC DATA RISK CATEGORY (pulled from most
recent date below)
date c1 c2 c3 c4 c5 Risk Category
1/1/09 Y Y Y Y Y Low
2/1/09 Y Y N N N High
3/1/09 Y Y Y Y N Moderate <--- want to retrieve
this for use in main form
I have a child table that has a date, a series of yes/no fields, and a risk
category that is a calculated field based on certain combinations of the y/n
fields.
The y/n fields will be logged monthly by date with some interest in the
historical data. I want to transfer the risk category that is associated
with the most recent date to a query of the main data set.
Example, My main form and report will be laid out similarly:
NAME SSN DEMOGRAPHIC DATA RISK CATEGORY (pulled from most
recent date below)
date c1 c2 c3 c4 c5 Risk Category
1/1/09 Y Y Y Y Y Low
2/1/09 Y Y N N N High
3/1/09 Y Y Y Y N Moderate <--- want to retrieve
this for use in main form