Excel if statement to Access

[ramiromunoz]

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!!!

 

[ramiromunoz]

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

 

[dhookom]

What is

trying to eliminate any lower level in a category

? There is nothing in your data or posting that suggests category.

Duane
Hook'D on Access
MS Access MVP

 

[ramiromunoz]

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 2's of which level two is a separate entity, so in a sense, all level 2's individually will become a level 1

Or, in other words, this is an indented thing, where 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

 

[ramiromunoz]

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

 

[dhookom]

Since this is Access, you have to understand that records are like marbles in a bag. There is not any order without some field or fields that store and identify the order.

Do you have any other field or fields that uniquely identify the order of your records?

Duane
Hook'D on Access
MS Access MVP

 

[ramiromunoz]

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.

 

[ramiromunoz]

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

 

[dhookom]

Maybe you should start over with a thread in the Microsoft: Access Queries and JET SQL forum and provide all significant information such as the table and field names with sample records and desired output.


Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Really, you unique identifier ought to be some sor of sequential number, it seems.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Really, you unique identifier ought to be some sort of sequential number, it seems.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}