Hi
This is the second query I have had with Dmax. The first one I resolved as it was in a form and by using DMAX everytime I click for new record it gave a new order number ie dmax("ordernumber", "tbl_orders")+1.
This problem is quite different and I am hoping someone out there can advice.
I have a group of orders in a table. I tick a box to select which records I want to batch for that particular month. An update query then copies these records to a new table ready for batching.
My query is that each row needs to have a unique reference number. I cant use autonumber as I must specify the first number at the beginning. After that each record will increment by one.
Thanks for your help. Hope all this makes sense
jacc14