Last tblChild.Field as Column

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

I have a Master/Detail

I want to show all the columns from Master, and one specific Column from the
LAST entered Row in the Child

Thanks!
 
Gary said:
I have a Master/Detail

I want to show all the columns from Master, and one specific Column from the
LAST entered Row in the Child

Thanks!
Click to expand...

How do you determine which the last row was? Each record probably needs
to contain a date/time value (time it was updated) if you wish to
determine this. Or you might be able to use something like an
incremental Autonumber field in the [Child] record. What does your SQL
look like right now?

You might try something like this, where the argument to the Max()
function would be the field containing whatever you use to determine
what was last entered:

SELECT Master.Mother, Master.Father,
Child.ChildID, Child.Name
FROM Child AS Child_1, Master INNER JOIN Child
ON Master.MasterID = Child.MasterID
GROUP BY Master.Mother, Master.Father,
Child.ChildID, Child.Name
HAVING (((Child.Name)=Max([Child_1]![Name])));


-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top