How do I set a rolling year based on an individual's first record?

[funwithaccess]

Hi everyone!

I wanted to know if it is possible to set a rolling year based on the first recorded date for an individual. In other words, my table is updated every time an employee receives a point. The record includes the employee's name (empName), the date (dateOfOccurrence), and the point (occurrencePoint). I would like to create a query that would be based on a rolling year from the very first record of an employee based on the first dateOfOccurrence. The first date/record of this employee would be the start of the rolling year. I am writing this in SQL in Access 2013.

Please help me create a foundation for this query. I would greatly appreciate it!

Thanks,
Nate

 

[SmallTomato]

Can you please post a small example of your current table and a sample of your expected results of the query? I am having a hard time understanding.

Thank you.