Hi

I am using MSaccess 2003 and I have a simple table that holds a schedule year...the table has three fields
date crew1 crew2


In my qry I want to display a weeks worth of the 3 columns
for example

date crew1 crew2
01/08/2006 A B
02/08/2006 B A
03/08/2006 C D

THANKS


i'M USING THE DATEADDFUNCTION WITHIN THE QRY'S CRITERIA BUT I'CANT GET IT TO WORK..

DateAdd("dd",7,[date])

pLEASE HELP