How do I select all the days in the current week from a date field?  I want
to view all the employees hired in the current week using the hire date.  I
do not want to enter the beginning and ending date of the week each time; I
want the query to look at todays date, look at what the week of the year
todays date is and then include all the hire dates that are included in the
current week.

Thanks,

Scott