Is this what your looking for - 4 columns: first,last,young, and old. Only dates with dob < 1980 go in the young column, others in the old.
select first, ;
last, ;
IIF(year(dob)<1980, dob, {}) AS Young, ;
IIF(year(dob)>=1980, dob, {}) AS Old ;
from member
- Mark