Calculating Age groups

[pbucc]

Hi there,

i have an Age field and i am trying to calculate the age field. i have never used the "<, >, <=, >=" before. now what i have works but anything over "45" doesn't work. what am i missing?

If(Age <= "25" , "25 and Under" , If( Age >= "26" or Age<= "45", "26 to 45" , "Older than 46" ) )

[The Bridge]

quote:

---

Originally posted by pbucc:

Hi there,

i have an Age field and i am trying to calculate the age field. i have never used the "<, >, <=, >=" before. now what i have works but anything over "45" doesn't work. what am i missing?

If(Age <= "25" , "25 and Under" , If( Age >= "26" or Age<= "45", "26 to 45" , "Older than 46" ) )

---

Change this to a Case() statement:

Case (Age<=25, "25 and under", Age<=45, "26 to 45", "46 or older")

[LeCates]

Hi pbucc,

Just for clarification, the problem with your calculation is the "or". If you change this to "and" your calculation should work.

But the formula posted by The Bridge is probably simpler/better to use.

Good luck!

quote:

---

Originally posted by pbucc:

Hi there,

i have an Age field and i am trying to calculate the age field. i have never used the "<, >, <=, >=" before. now what i have works but anything over "45" doesn't work. what am i missing?

If(Age <= "25" , "25 and Under" , If( Age >= "26" or Age<= "45", "26 to 45" , "Older than 46" ) )

---

[pbucc]

Thanx they both worked.