>How can I programatically change the values of a particular field in a table without changing any of the other fields? I have a table that imports specific records from another table but I want one of the fields (which imports the different dates) to be changed to a specific day programatically. The day should always be a Wednesday and I would use the following line of code so it would be something along the lines of this:
>
>Update TableA.datefield.value = DATE() - DOW(DATE()) - 3
>
>I know the above coding is wrong but what do I need to write to make it work?
>
>Thanks!
>Max
Basic replace:
SELECT TableA
REPLACE TableA.DateField WITH DATE() - DOW(DATE()) - 3
HTH :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca