Search results for query: *

Actually THERE IS one column that contains a unique identifier. The unique identifier

Unfortunately there is no other field that can be used as a unique identifier. I guess all of the sorting and identifying will have to be done in Excel, then transferred to Access only the lower levels.

This is how it should be read like this: (I just want to see the lowest of each line) LEVEL 1 ..2 ....3 ......4 ..2 ....3 ..2 ..2 ....3 ......4 ........5 ......4 ..2 ....3 ......4 ........5 ....3 ......4 ........5 ......4 ........5 ......4 ........5 ....3 ......4 ........5 ..2 ..2 ..2

Ok. This can be read the following way. Level 1 is the final product made from all of Level 2's Level 2 is the product made of all from the underlying level 3's Level 3 is the product made of all from the underlying level 4's (and so on and so forth) A level 1 most likely has multiple level...

forgot to mention that the Level column will have the following - and my query will only display the bolder numbers LEVEL 1 2 3 4 2 3 2 2 3 4 5 4 2 3 4 5 3 4 5 4 5 4 5 3 4 5 2 2 2

Hi, I would like to convert the following statement to Access, but I can figure it how. The statement reads: =IF(A1="level",A1,IF(A1>=A2,A1,"")) The column name of where the number resides is "LEVEL" pretty much I am trying to eliminate any lower level in a category. Thanks!!!