I have a table with various information about work orders done in our shop.
When I am adding a new job, I would like access to look at the last record or highest work order number and add 1 to the number for the next job, I thought you could possibly do a query and put +1 in the criteria, but what type of query would it be. Or maybe I am totally off.
Thanks
Jay Morlan
When I am adding a new job, I would like access to look at the last record or highest work order number and add 1 to the number for the next job, I thought you could possibly do a query and put +1 in the criteria, but what type of query would it be. Or maybe I am totally off.
Thanks
Jay Morlan