expression comparing past/current doners

I have a table that includes all of our donations for the past three years.

I'm trying to produce a query that essentially gives me all doners who have given to donation type a, b, or c, in 05/06, but haven't given to donation type a,b, or c in 07.

Can anyone point me in the right direction to achieve this expression?

Do you have a a column in sthe spreadhseet for the following columns

Doner, Year, Type

There's a Donor, Date, and Type field. Donor is two fields, first name and last name, but the individual donor contact info is stored in another table with auto assign primary keys.

try using a pivot tbale
1) combine first name and last name into one column. call it full name
2) create pivot table
3) add fullname, and donation type should to the row section
4) add year to the column section
5) add fullname into the data area