numeric field look up

[CosmaL]

Hello dear friends,


is it possible into a table containing numbers from 1 to 100, to run a query and find if there's any missing numbers?


Thank you in advance!


Costas

 

[pbaldy]

The only query solution that comes to mind would require a table that does contain all the numbers. You'd run the unmatched query wizard comparing the two tables.

 

[The_Doc_Man]

If the numbers are unique (i.e. no duplicates) then do a DCount and see if you have 100 records. Now if you want to know which ONES are missing, Paul's answer is correct. But if the question is simply "Are any numbers missing" then the answer is to count them if they are otherwise unique.

 

[CosmaL]

Thanks guys!


pbaldy's advice is working fine!

 

[pbaldy]

Happy to help!