HI,

i got a problem writing formula in crystal report 9.
i m just new to crystal report.
i have a table and fields are like this:

ID - ItemNumber - Date
------------------------------
01 - 000111        - 11/11/2008
01 - 000222       - 11/11/2008
01 - 000255        - 11/11/2008

i want to write a formula to get the smallest ItemNumber if the ID are same.

The output on report should be the first record which is:
01 - 000111       - 11/11/2008

Thanks in advance....