I am trying to replicate the Group By and Maximum function within from Access query into Crystal 2008.  When I use the Maxium function in Crystal Report it was telling me that I am missing a Boolean function.

 

What I am trying to do is:

 

ID     Date              Status Code

--      ------              ----------------

01    01/01/2008    03

04    01/01/2007    01

01    01/01/2007    03

05    01/01/2007    02

01    01/01/2003    02

 

Group by ID and select the maximum date associated with the ID then further eliminate the report output by Status Code <>3.

 

FINAL OUTPUT DESIRED

ID     Date              Status Code

I need help to group by ID and only have the maximum date associated with the IDshow...how would I go about doing so?  I am able to eliminate the Status Code <>3 by using the Select Expect - Record but that's step 2.

 

Any advise would be greatly appreciated!

 

Thanks. M