Trouble pulling most current record

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have a query/table set up like this below.

I have managers that go on "leave of absence" and transfer districts.

I want to show on a form the most CURRENT infomration but the form is
pulling the first record. The most current is the last record (in this
situation). How can I either put a conditional formatting on this for
"Status" or run a query to pull the last information.
Any suggestions?

DistrictCode ManagerID StartDate EndDate EndReason
LOA 36 6/29/2009 8/21/2009 Return from LOA
7838 36 6/29/2009 LOA LOA
7838 36 8/24/2009
 
Use a query to populate the form. The sort on the StartDate in descending
order.

Remember that First and Last really are meaningless in a database unless you
first sort the records. The order that you type in the records does not have
anything to do on how the records will be returned.
 
Back
Top