I want to create an invoice number in a query. The number created will be appended each month to a table for tracking purposes. So some how the invoice number will need to be unique in each query. Any suggestions?
Invoice number can be I guess upto 6 digits and a variable.