I need to automatically enter a unique date on a report (an order form) which incorporates today’s date and a unique two-digit identifier, which resets when the date changes, eg on 25 July 2011 I might issue three orders, the last being 11072503. On 26 July I need to start at 11072601. Putting them in manually is not an option as several people will use the database and will not necessarily know what the last person has done. Whatever help you can give would be much appreciated – I am not an experienced database designer.
