i have a table as checkpoints and it has creation date and some other informations and this creation date is a field as date/time
i add data from this table to anothr table, this table has a project name field and for each project i will add the checkpoints from checkpoints table until a specific dtae
this date is a textbox in my form in ms access, but after a while some other data is added to this table and iwant to add them as well but i don't know how. can you help please?
i wrote the follow code but it adds just the new date once but i want to add it for each of my project fields for exxample
insert into checks_projects([Creation date]) select a.[Creation date] from (select [Creation date] from Query2) as a left join checks_projects b on a.[Creation date]=b.[Creation date] where IsNull(b.[Creation date])
can you help please?
i really need it