Someone please help me to search unused number in mdb ordered number list
Eg:
From 1-10 I used these:
1
2
3
5
7
8
And unused these:
4
6
9
10
How can I search it?
Tx 4 ur help
Printable View
Someone please help me to search unused number in mdb ordered number list
Eg:
From 1-10 I used these:
1
2
3
5
7
8
And unused these:
4
6
9
10
How can I search it?
Tx 4 ur help
You could use a FOR-NEXT loop
and inside the loop lookup for the record for that number
Following your example:
you didn't say if you're using ADO or DAOCode:FOR X = 1 TO 10
Search your recordset with X
If the search fails then is UNUSED else is USED
NEXT X
I am using ADO, thanks 4 ur answer, I will try it