Trouble pulling most current record

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
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Most recent date prior to test date. 1
Getting most recent detail record for each master and associated fields 1
Date between two Dates 2
Pull most current Invoice 2
query to update data 2
How to run a macro from a form for the current record only 2
Record calculation issue 4
Selecting the Most Recent Date From one unique ID 4

Top