using a querie as a filter

[qurn]

First let me say that I have been reading these forums alot recently. I knew nothing when I came here and you guys have been a great help. Now heres my problem.

I have a table for amusement businesses. I have colomns for inspector, insurance exp. date, and year they have applied for licences. I've mannaged to to sort out the ones that have expired insurance and expired licences. Now I need, above all else, sort it by inspector, so each inspector can see wich one of his assighnments needs to be checked up on.

Heres my code

SELECT Yearly.[Co licence #], Yearly.[operator name], Yearly.inspector, Yearly.[inurance exp date], Yearly.[2005], Yearly.[2004], Yearly.[2003], Yearly.[2002], Yearly.[2001]
FROM Yearly
WHERE (((Yearly.inspector)="DP") AND ((Yearly.[comments 6/2/2005])="follow up")) OR (((Yearly.[inurance exp date]) Between #1/1/2004# And #6/2/2005#));

I can tell already that this is a bit embarising, but like I said I learned everything I know from here.

thanks in advance.