hi
I desperatly need help with crystal reports.
i am trying to create a report that counts the number of full-fiscal years that a FULL-TIME employee has worked.
Variables:
status: can be either fulltime, parttime or temporary
begindate: date that the job began
enddate: date that the job ended

fiscal year runs from July 1 to june 30

if an employee works just 1 day during the fiscal year as parttime that fiscal year does not count.

If an employee begins a job position on july 2 that fiscal year doesn't count because it was missed by 1 day.

i am using 1 table and each time an employee changes job positions a new record is created and added to that table
Any help would be appreciated!!!!!!
jodilyn =)