I have a list of 10,000 numbers and need the 10,000 one to be the.

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

Guest

I have a list of 10,000 numbers and need the 10,000 one to be the first. The
99,999 one to be the second and so forth. I basically need a complete
inversion of all of the numbers.
 
From what you posted, we don't know which software you are using. You need
to post at least the name of the software you are using (including version
and service pack number) and your O.S. ...

This newsgroup is meant for Microsoft Access, a database application but if
you look in other threads, you can see that there are lots of posts that
were meant for other newsgroups because posters often think this newsgroup
is for general computer "access".
 
Presuming you are working with MS Access

Set the key field to [KeyField] autonumber, increment
this would then give me numbers 1,2,3.....
then when I needed the 'inverted number' use the following in a query

Inverted:10,000-[KeyField]+1


Ed Warren
 
Except that autonumbers are not guaranteed to be either sequential or
positive.
Given the original question why not just specify a descending sort in query
designer?

Ed Warren said:
Presuming you are working with MS Access

Set the key field to [KeyField] autonumber, increment
this would then give me numbers 1,2,3.....
then when I needed the 'inverted number' use the following in a query

Inverted:10,000-[KeyField]+1


Ed Warren


inversion said:
I have a list of 10,000 numbers and need the 10,000 one to be the first.
The
99,999 one to be the second and so forth. I basically need a complete
inversion of all of the numbers.
 
That what I would recommend in Access but I am not even sure the O.P.
referred to a problem in Access.
 
Back
Top