How do I only extract most recent date, with all other data associated with the record, from a query with multiple entries for one student?

My dilemma,
I’m trying to develop a query where I can extract a student’s last enrollment date along with all other data associated with that record.  Using the “Last” option in a crosstab query I can extract the last enrollment record only when the student ID# and the DT_Entry and DT_Withdrawn fields are present.  When I add the rest of the fields to the query the crosstab “Last” option does not work.  I get all the records for all the students.  In the example data below for student# 008876, I would like to only extract the fourth record.  That record tells me the student is still enrolled because the DT_Withdraw is blank.  For student# 009201 I want the query to extract the last record (in the example below). This record tells me this is the most recent (last) enrollment however the student has withdrawn.  

Table
CAMPUS_ID         STU_ID       DT_ENTRY     DT_WITHDRAW            WITHDRAW_CD       ACTIVE_CD
001                    008876       20060814       20060814                             44                         2
001                    008876       20060815       20060907                             60                         2
005                    008876       20061101       20061114                             30                         2
005                    008876       20070124                                                                              1
001                    009201       20060814       20060814                            44                          2
001                    009201       20060922       20061025                            49                          2
005                    009201      20061025        20070108                            49                          2
001                    009201      20070108        20070120                            80                          2

The desired query result will include all data pertaining to these records, there are 12 other fields to the query.
Example query result.

CAMPUS_ID        STU_ID       DT_ENTRY     DT_WITHDRAW            WITHDRAW_CD          ACTIVE_CD
005                    008876       20070124                                                                                1
001                    009201       20070108        20070120                            80                          2


Thanks in Advance.
Start Free Trial