Update Column With Autonumber

I need to figure out when each person will complete a task based on a work calendar that won't include sequential dates. I know the data in two tables T1 Name DaysRemaining Comple

Solution 1:

I think this will work:

select t1.*, t2.datefrom t1, t2  -- ms access doesn't support cross joinwhere t1.daysremaining = (select count(*)
                          from t2 as tt2
                          where tt2.date <= t2.dateand tt2.date > now()
                         );

This is an expensive query and one that is easier to express and more efficient in almost any other database.