Complicated Calculated Field Logic

Jun 7, 2012
Reaction score
I'm new to access and database building in general. I'm trying to calculate a college student's classification based on the number of completed credit hours they have. I have a field called "Credit Hours Completed" and I'd like to use the following logic to automatically display a text value for their classification.

If [Credit Hours Completed] is < or = 29 then print("Freshman")
If [Credit Hours Completed] is within range 30 to 59, then print("Sophmore")
If [Credit Hours Completed] is within range 60 to 99, then print("Junior")
If [Credit Hours Completed] is > or = 100, then print("Senior")

I've read through the Access Help on IIF statements and I'm not sure how to string them together or apply this logic to them.

I'm wondering if this logic is too complex for a single calculated field? If so, can anyone think of a way I could emulate this across multiple fields? If not, can anyone give me a hint as to how I might write this?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question