I want to update time with difference of 4 min, for particular set of records. for example time
03-06-2015 11:45:37 AM.
Now I want to update range of records define by with time difference of 4 min i.e.
03-06-2015 11:45:37 AM,
03-06-2015 11:49:37 AM,
03-06-2015 11:53:37 AM,
03-06-2015 11:57:37 AM,
03-06-2015 12:01:37 PM,
03-06-2015 12:05:37 PM
i wrote query but it is not working...
the query is
UPDATE <TableName> SET <Field Name>= DateAdd("n",[Field Name] * 4, [StartTime])
WHERE (<Field Name> >= [Start] AND <Field name> <= [END]);
Please let me the what is issue