How to create a request that aligns the n registrations and n-1 ?

  • Thread starter Thread starter Famille LE PETIT
  • Start date Start date
F

Famille LE PETIT

Hello.

I have a table that counts a set of neat indications to which are
associated two values.
In a calculation that I must achieve, I must have n and n-1.

Either to be more precise :
Table of the indications
IdIndice Taux1 Taux2
1 A1 A2
2 B1 B2
3 C1 C2
Etc.

I would like to get the table or the following request :

IdIndice Taux1 Taux2 IdIndiceNext Taux1Next Taux2Next
1 A1 A2 2 B1 B2
2 B1 B2 3 C1 C2

Question: Is it possible to create the second table with a request?

Of advance, I thank you for your contributions.
Cordially, Arnaud
 
As long as your example is literal in that you can use n-1 as the key to the
record you need -- create a query that calculates a new field of n-1 (eg
JoinID: IdIndice-1) and includes all other fields.... then save that query
create a new one with your new query and the original table -- and join
'JoinID' back to your original table IdIndice and pull it all together.
 
Thank you very much
I didn't know that I could use the IdIndice-1
The result is in conformity with my waiting.
Arnaud
 
Back
Top