First/Last Expressions Help

[scgoodman]

I have a query that pulls a status. Within that status there is a sequence number associated. I want to pull the last status within that dataset, however when I setup my LAST expression it pulls the first date.
Here is some sample data below: I want to pull the last status entered. Can anyone help?
I have attached a file for review

 

[Alansidman]

Is that one line of data? Or were you trying to present something else. What is the data you are looking to extract. How is it laid out in a table? Is this in a text file. Looking at it is very confusing.

 

[scgoodman]

Sorry, I attached a file that is readable.

 

[Galaxiom]

First and Last are next to useless unless you don't care which record is selected. They just take the first record they come across.

Use Max or Min on a field that can be ordered.