I think this is pretty advanced, and I have been beating my head all day over it. I need to create a field titled "ProjNo" in table that is numbered in the following fashion 2006-001. Not tricky if you use autonumber and set 2006 manually as the static value. I however want to have it re-index next year, and also pull old data from tables and take the date from a field titled "Dateadded" that actually carries the date in the foramt dd-mm-yyyy. Basically I know it is a DMax() function but this datbase was written by someone else so it would be much easier for me to do this on te table side of things, instead of the form side like someone told me to try (I think that would make migrating all the old data over a bear). Thoughts? Even if some just write something simple with three fields I would be really happy.