Auto Number to Reset Daily (PO #)
I'm trying to create a PO #. They want to include the date and a sequential number in the PO #, e.g.
I can use the "Auto-Number" function, BUT... they want the number to reset back to 1 for the next date... which auto-number doesn't do.
Is there a way to do a running count that would basically add a number for each row added on a given day?