Queries on how to add potential units to a another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Eg

I had a 2 table

one table called A and it contains a column called numbers.

i wish to create a query to add the potential numbers to it and update a
another column.

If the nos is 1 and the next potential is 4 or 7 or
if the nos is 2 and the next potential is 5 or 8 or
if the nos is 3 and the next potential is 6 or 9 or

Please help.
 
for example

1347 and the next potential is 1344 or 1341 or
1347 and the nxt potential is 1317 0r 1377 or
1347 and the nxt potential is 1647 or 1947 or
1347 and the nxt potential is 4347 or 7347 or


another option is to +1/-1 or +2/-2

eg

1347 --- +1/-1 = 1348/1346

please help!!!!
 
Back
Top