I am trying to get the right syntax to use the DateAdd Function. Here goes
I have a field in the tbl Student Data titled DATE_ADDED. I have an append query setup to add data to a another table (Booking).. I can't get the syntax right to make it work.
This is what I have. I want it to append the data to matching fields in the booking table meeting the following criteria of 10 seconds after it is added.
>DateAdd("s",10,[DATE_ADDED])
It recognizes it as proper syntax because it doesnt error out but it doesnt do anything with respect to appending data.