**Edit 4:**

I was finally able to solve my own issue. See checkmark answer below.

**Edit 3:**
I feel like I'm really close to solving this, just one hurdle remains in my way. Filters can only be applied in list boxes, combo boxes, or drop down list boxes. I am able to get my information filtered, but I need to get a MAX value for the information I've filtered and I have no idea how to do this. I've tried the max function and all I'm getting is NaN.

See [screenshot](http://i.stack.imgur.com/jiXZH.jpg).

You'll notice my "Current Year #s +1 defaults to NaN. But when I select a number from the filtered drop down, it works. I need to be able to default to the max number in my list.
See another [screenshot](http://i.stack.imgur.com/1YF0R.jpg). I can't seem to figure out how to default to the max report number. Any suggestions or ideas?

**Edit 2:** 
Question still remains unanswered. Going to move most recent edits to the top.

**Edit 1:**
It seems like we are going with Ktharsis approach. He suggested using a filter for the year before we get the MAX(@ID) +1. I'm not sure how to implement this yet. Is there a formula to filter for the year in Sharepoint before getting the MAX(@ID) +1 so that our sequential IDs will reset for each year? I will post another update once this is answered.

I am trying to create a unique number counter ID that will reset on the new year. I have the number counter part down, but I have no idea how to make it reset when a new year begins.

Example: 2010-0057, 2010-0058, 2010-0059..... 2011-0001, 2011-0002 etc.

Instead it's just continuing the sequence. Any ideas on how to implement this? The preferred method is without the use of programming. On a side note, I am integrating this with a SharePoint site and I am actually getting my sequential number from SharePoint's ID field. I am using a MAX(ID) formula for my number sequence.

\*\* First time using this site so I am sorry if this question doesn't belong here.