I have a table:
Here is what I need to be able to do:
The BatchNumber needs to always start with 900 for each new day and as records are added the BatchNumber is increased by one.
At the start of a new day, the BatchNumber needs to start again with 900.
Anyone got any suggestions?