Query to add potential nos to list in Table

  • Thread starter Thread starter Wilie Loh
  • Start date Start date
W

Wilie Loh

How to add potential nos to list in table but append to column in another
table?

2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
0169
0367
0468
1256
1267
1368
3889
4999
5568
6777
0148
0889
1146
1235
1357
1477
1489
4579
4668
4899
 
Dear Wilie Loh:

Your question does not supply sufficient details to permit me to understand
the basis for what those potential numbers should be.

One might presume uniqueness is a factor. However, it is not clear why 2899
would be a potential number for the row 2499 but not for the row 3678. Or
is it? How are potential numbers restricted or otherwise based on the value
in that "column in another table."

I hope you can understand why there is little comprehension here of what you
need, and that you can explain it.

Tom Ellison
 
Dear Duane:

I expect perhaps you mean the same level of non-understanding. As in, total
non-understanding. I have no idea what he wants. I just hope he can
express himself as to what he needs so someone can help.

To Wilie Loh: in what language would you be most comfortable? We may be
able to direct you somewhere that it is easier for you to express yourself.

Tom Ellison
 
The other responder in the tek-tips thread is fairly good at guessing
underlying needs and it seems we are all equally confused.
 
Back
Top