I have two tables - both have dates in them, and Table A has an additional date field that is currently blank. I want to populate that with the date from Table B that is equal to or the next biggest as the date in the other date field in Table A. I wrote this, but it's not working:
UPDATE TableA, TableB SET TableA.New_Date = TableB.B_Date
WHERE (((TableA.Old_Date)<=TableB.B_Date));
Any ideas?
UPDATE TableA, TableB SET TableA.New_Date = TableB.B_Date
WHERE (((TableA.Old_Date)<=TableB.B_Date));
Any ideas?