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!!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to add potential nos to list in Table 4
how to solve 1
selecting nos 2
arranging in particular order 1
Query to find missing data 4
find balance nos 3
selecting nos from table 1
Create a Query to pull a list of records from large DB 2

Back
Top