I am new to Crystal Report 8.5 but I need a formual to determine students as new student for the under the very first academic year via their term while any other academic year moving they should be noted as returning student. Here is a sample of the database.

Student   Academic Year    Term
Baba       2001-02              Fall
Baba      2001-02             Spring
Baba       2002-03             Fall
Baba     2002-03             Spring
Baba    2003 Summer      Summer

Fatu    2005 Summer       Summer
Fatu    2006-07                Spring
Fatu    2007-08               Spring

Adams  2002 Summer      Summer
Adams  2004-05               Fall

From the above Sample data, I need a Formula to display the following on this students record.


Baba should be "New Student in "2001-02" in Fall and any other Academic year and terms he should be a "Returning Student"

Fatu should be "New Student in "2005 Summer" in Summer and any other Academic year and terms she should be a "Returning Student"

Adams is a new student in 2002 summer in summer term while any other year he remains a returning student

Thank you so much . It does displays " new Student " and Returning Student but the problems are as follows

1)I cant seem to get the count of new student  and returning per Term and each Academic year

2)If they student attended Academic year 2001-2003 and then attended both Fall and Spring that formula display new student for both  term.

Because the if {Enrolment.AcademicYear} = Minimum({Enrolment.AcademicYear}, {Enrolment.Student}) then
    "New Student"
else
    "Returning Student"  is a formula it does not give the option for a running total or grand total

Rvlink,

Thank you for your help on this formula.  Your initial formula gave me a stepping stone to finish the formula, it took 106 formulas to get the job done.  Once again Thank you so much.