I am planning to add a sequential number to a date field in an Access form. The format which I am using for it is PR 1 Feb XX, the PR is fixed, the present date as well as the XX is my sequential number I would like to add. Is there a means, to perform this at what time the date is entered? And I will require the sequential number on the way to reset to 01 by means of a new day.I am new to this, any assist would be greatly appreciated.
Bookmarks