Issue: My database is structure in a hierarchical manner. The field is termed Tree_Structure_Path. I need to tag entries (matches in another table) and all entries lower in the hierarchical path for use the information from the previous record. To do this, it appears a need a sequential number.
I'm an Access Novice: I've read quite a few posts, but I do not understand the components of the statement.
I've created this formula but the numbering is not entirely sequential.
Seq: DCount("Level_ID","XXXXXXX_Wrp_Levels","Level_ID <= " & [XXXXXXX_Wrp_Levels].[Level_ID])
I have attached the table Structure & query results.
Any help is appreciated!