D
Daniel
Hello,
I found the following searching for a query to find gap in a sequence of
numbers
This will find the first number of every gap in the sequence:
SELECT T.num + 1
FROM table As T LEFT JOIN table As X
ON T.num+1 = X.Num
WHERE X.num Is Null
It was originally written by Marsh MVP [MS Access]
When i try to execute it (Access 2000) I keep getting an 'Join Expression
Not Supported'. I've verified the synthax. What is wrong?
Thank you.
Daniel
I found the following searching for a query to find gap in a sequence of
numbers
This will find the first number of every gap in the sequence:
SELECT T.num + 1
FROM table As T LEFT JOIN table As X
ON T.num+1 = X.Num
WHERE X.num Is Null
It was originally written by Marsh MVP [MS Access]
When i try to execute it (Access 2000) I keep getting an 'Join Expression
Not Supported'. I've verified the synthax. What is wrong?
Thank you.
Daniel