I have database with a primary key that is 4 random numbers 0001-9999 is there a query that i can run that will give me all the numbers that are not used in that series?
No, although you can run a query that tells you if a number is being used. You could use a little bit of VBA and SQL to create a function that returns if a number is being used or not, and use that to test instead.
