Hello,
I have a query that has the date the record was recorded. I also have a non linked table that has all the Friday's (End of week) in it for the next few years.
What I'm trying to do is this;
If the date would be 12/23/2008 then add the record 12/26/2008 in the query to the "new" column...