Query Malfunctioning

[CJ_London]

If the query fails, it has to move onto the next sequence automatically. It isn't that the numbers aren't in order.

not sure what you mean by that. suggest provide examples.

[AccessPower]

not sure what you mean by that. suggest provide examples.

Yeah. That doesn't really make sense.

What I mean is if this is my list, everything would pull correctly using that query:

H1110
H1112
H1113
H1114
H1115 <--The query should pull this
H1116 <--The query should pull this
H1117 <--The query should pull this
H1118
H1119 <--The query should pull this
H1120
H1121
H1122
H1123
H1124
H1125
H1126
H1127
H1128
H1129

By my list looks more like the one below, so the query is pulling the wrong set of numbers:

H1110
H1112
H1114
H1115 <-- The query will pull this. The query needs to skip this since there are no numbers ending in 7 or 9 that have all other characters the same as the 5 and 6.
H1116 <-- The query will pull this. The query needs to skip this since there are no numbers ending in 7 or 9 that have all other characters the same as the 5 and 6.
H1118
H1121
H1123
H1124
H1125 <-- The query will pull this.
H1126 <-- The query will pull this.
H1127 <-- The query should but won't pull this.
H1128
H1129 <-- The query should but won't pull this.

That's the issue.

[CJ_London]

suggest upload a db with some sample data - both tables. I can't see anything wrong with the logic at the moment. compact the db and zip it