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

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200708/1