• Hi

    I'm sorry to answer your questions with a question but we need to know what method you are using to increment from 0000 to 9999.

    If you are using an auto increment data type (that is incrementing by 1) then the answer is simple - use a max (query) or dmax (VBA) function. If you are using code to do it and the numbers aren't sequential then it gets more complex.

    The answer will also depend on whether you are attempting to do this in a query or VBA.

    Cheers

    Rowan