Search results

Hi I have maded a simple macro which completes query which makes a new table. After that the macro saves the changes and closes the Access. Everythig works fine when I complete the macro from the desktop icon. But when I try to complete the macro from Windows scheduled task (in every three...

Thanks. I tried that but when I try to complete the query Access says: " Compile error. in query expression 'DateAdd("n",-2,[StartTime])' ". Any other suggestions how to get it work? Yes I say one minute but I meaned two:) Yes I got it work in my other database, strange that it didn't work at...

Hi I want reduce one minute from my date field. My date field looks like this: 17.3.2006 3:57:00 and I want it to look like this:17.3.2006 3:55:00. I have tried to make it like this: DATEADD( minutes, -2, [StartTime]) AS NewStart. StartTime is date field. But this doesent work. Could somebody...