I have a table and a query that lists bill numbers and adjustments. I want to create a field/formula similar to an auto number where the first instance of a bill number will be assigned 000 and then increment up 001, 002, 003 until the next bill number is reached at which point it will restart at 000. I have a date field which will define the order of bills within each bill number. Any help would be much appreciated.