Missing Ids

[GJT]

I need to create a query that will return from the table all Id records that do not exist from a run of 1-n ......

i.e. for 1-10: the table contains the following Ids
1,3,4,5,7,8,10

The query will return :
2,6,9

Has anyone done something similar?

Thanks

Guy

 

[Mile-O]

As you can only query on what you have got and return records from the source then you will be unable to do this with queries. You are wanting to return records that do not exist.

It would be possible, however, to do it with Recordsets via code.