Ok,

I'm trying to create a report in Access and I pretty much built the report but I wanted to know if there was a way to add a line after each entry without using the "block" design for the report.

Then, I have an AutoNumber that I designated as the File Number. I made the file number so that it automatically assigns the number when you start typing in the form. BUT... the thing is the way the file number is determined. our file number is as follows (ex: 350-09-543). The 350 is our department number, 09 is the year, and the last four begin with 0001 and increase each time. My question is, how do I get the 09 in the File number to change to 10 when January 1st comes?

Any assistance is greatly needed and appreciated!!

cristinaemorales@yahoo.com