ok ...i've got a field on a table which is for invoice number.
i already have an auto number for the table id.
i need to be able to enter a start number in another table
and get selected records in the first table to update the invoice number field incrementally starting from the start number.
after this is done i can do a "last of" query to update the start number table. or i can manually create a new start point without altering the previouusly entered numbers in the invoice number field.
so i need to know how to make a query which will produce a set of numbers (if 5 records are due for update, there will be five numbers) starting from the predetermined one. then i need to update the invoice number field then i need to update the start point number.....
should be easy but i think i've thought about it to long and gone mad.........
ps not all records have an invoice number so some will remain null
thanks in advance.... kimbo
)
i already have an auto number for the table id.
i need to be able to enter a start number in another table
and get selected records in the first table to update the invoice number field incrementally starting from the start number.
after this is done i can do a "last of" query to update the start number table. or i can manually create a new start point without altering the previouusly entered numbers in the invoice number field.
so i need to know how to make a query which will produce a set of numbers (if 5 records are due for update, there will be five numbers) starting from the predetermined one. then i need to update the invoice number field then i need to update the start point number.....
should be easy but i think i've thought about it to long and gone mad.........
ps not all records have an invoice number so some will remain null
thanks in advance.... kimbo
)