I have a field in my table that is called OrderNo. This order number is based on todays date. Only the user has to look at a table to figure out what todays date is in Julien and thn they add a sequential number to the end. Like if today was Jan 1st and this was the first record for the day the Order no. would be 001-001 and if it was the second record of the day then it would be 001-002 and so on until the next day then it would be 002-001. Make sense?
Is there any VB code that could do this. I am using Access 2003.