Oooh.. I just noticed that your table is called Date - that is a very bad idea, as it is a reserved word (which I'll actually use below!). It is likely to cause issues for you, and should really be changed to something different (possibly CrewDates).

You haven't specified what week of data you want (such as from/to certain dates, etc), but this will give the week starting today (untested):
SELECT Date.crew_schedule_date, Date.crew1, Date.crew2
FROM [Date]
WHERE (((Date.crew_schedule_date) Between Date And DateAdd("d",7,Date)));