Hello Everyone,<BR><BR>I have been trying to create a view for my users so that they can retreive a seven day outlook of their schedules. I am growing lost now because I don&#039t know how to write a sql statement that will produce such a view. I have been told that I am doing some illegal operations, or the fields are mutually execlusive or something so I don&#039t know what to do. The table is called tProjectEvents and the fields that I have are startdate and duration. I am trying to write something where events that may last for more than one day are shown in the seven day outlook. Below is what I have and it is completely wrong I am sure. If you have any ideas I would greatly appreciate it. <BR>Thanks.<BR><BR><BR>SQL = "SELECT * FROM tProjectEvents WHERE GroupID " _<BR> & "= " & objSharedRs("GroupID") & " AND StartDate + 3"_<BR> & "Between #" & Date() + 1 & "# AND #" & Date() + 7 & "#"<BR>objPTWCalRs.Open SQL, objConn