I have a table with Student birthdates. I calc a field called age. However, what I really want to graph are age ranges. I have tried to say Select student.age as Age25, student.age as Age25-50, student.age as Age50 from Student where Age25<=25 and Age25-50 Between 25 and 50 and Age50<50.
However, when I try this, Access interprets the alias names as new fields and expects me to enter what it thinks are parameters called Age25, Age25-50 and Age50.