Luis - Thanks for the clarification of the APPLY command. The links were very helpful. I also appreciate the link to how to post code for a better...

Thanks everyone for responding.

How to calculate the age is not the issue. I know there are many was to do so, but somehow I got my head...

Lynn

I should have known better re: an IF. I was getting desperate.

The following query works on it's own

The goal is to find out how old a student...