subquery

[analytics2006]

I need some help with a report I am working on. Please see the table listed below.
I have a table contains all the historical data and I need to create a report which will show when the "type" column was modified each time between the most recent "date" and the previous date (4/05/07 and 4/13/07). For example, Type was changed from "NAN" to "NSN" between 4/05/07 and 4/13/07. I am thinking I can use subquery to produce this report but I am not sure how to start this. Does anybody know what are the best way to do this in crystal?? I am connecting to a oracle database and using crystal report version 10.

thanks

acct# inv# type date

ZX512 a255 CNN 11/16/2006
ZX512 a255 NSN 1/4/2007
ZX512 a255 NAN 4/5/2007
ZX512 a255 NSN 4/13/2007

 

[analytics2006]

Can anybody help me please??

thanks

 

[Madawc]

Group by type. Use Report > Report Sort Expert to put them into date order.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10