A couple years ago I took over maintaining a preventive maintenance DB. There is one aspect I haven't been able to fix. To say I'm not the most qualified VBA person would be an understatement, though I know enough to believe its the answer to this question. One of the functions of the DB is to generate a document called a Request Work Order (RWO), (And of course the resulting record in a table) that is a generic blank work order anyone can do to request you guessed it, work. Anyway, the original designer decided that the RWO numbering scheme would be the Date Serial plus a sequential 2 digit suffix, in other words the first RWO issued today would be 42997-01, then 42997-02, and so on. Tomorrow the first RWO would be 42998-01, etc. I would love to auto generate this number for the users, but I don't have the chops to do it. I assume, that the Date Serial for today must be stored somewhere until tomorrow after the last time the dB is closed for the day for comparison, so that the suffix sequence can be reset to -01 each day. I'm not looking for the answer, but would really appreciate any nudges in the right direction.