Automate different document numberring for different depts? (1 Viewer)

Hi All,

Can anyone advice me on how can I automate document numbering by different depts?

Example:
Dept A - document no. (1000-1999)
Dept B - document no. (2000-2999)
Dept C - document no. (3000-3999)

Whenever a new document is created for that particular dept, the system should remember the no. and +1 for the next new document.

Thanks

what will you do when Dept A has set up 1999 documents? (30 years in the business tells me it will)

the easiest system is to use the DMAX() function to return the current maximum document number then add one and use that for a new document.

Plenty of examples here