I am working on a report where the end user would like to say giving me data
for quarter 1 of 2007,ect.  The data in my table has the year and date fields.
How do I begin to start this query?  I know I can say @Year for the year
parameter, but I am not sure how to get it to return ...

I log all actions of the users in a table. Each day, I create this 'logtable'.
It looks something like this:
Tablename: 20071207 (for logs of dec 07, 2007)
   Recnr