>>Hi all
>>
>>This kind of query should be common yet I often seem to break it.
>>
>>Two tables
>>
>>Members, StatusHistory.
>>
>>Status history has the member id the status and the date of the change.
>>
>>I want to grab member info and the current status and change date as of this moment for each member.
>>
>>Please help.
>>
>>Thanks!
>
>Mike,
>I am not sure I understand what you want.
>You just want to update records in StatusHistory with new date and status, you want to insert new records in that table with new date and status or you want to update member's info for these which are already in StatusHistory and Add new records for these which are not there. Can you post some data and desired result?

Hi Borislav

I don't want to update the statushistory. That will be done in a screen specifically for that purpose. I want to produce a listing of each person with their current status and when it changed.

member
id       name
1        mike

statushistory
id    status    effdate
1     I         01/01/2005
1     A         01/01/2007

result
id     name    status  effdate
i      mike      A     01/01/2007