Forum Discussion

rolo1007's avatar
rolo1007
Copper Contributor
Mar 25, 2020

Sequencing based on the Value

Hello, I am trying to develop a sequence where the number resets to 1 when it encounters a new ID (Primary Mnemonic in this case). Example: Primary Mnemonic Sequence Bill 1 Tom 1 ...
2016
access
George Hepworth's avatar
George Hepworth
Steel Contributor
Mar 25, 2020

rolo1007 Allen Browne has many foundation methods and demos, including this one  which may address your needs. Post back if you can't figure out how to apply it to YOUR specific table.

rolo1007's avatar
rolo1007
Copper Contributor
Mar 25, 2020

George Hepworth 

 

Thank you! I did see that when I was trying to research it, but wasnt sure how to formulate to my information.

  • George Hepworth's avatar
    George Hepworth
    Steel Contributor
    Mar 26, 2020

    rolo1007  Does that mean you haven't worked out the query yet? Perhaps with some actual sample data (not pseudo data created for an example), we could help you with that.