jsom set datetime to null

use null ;)

sharepoint worklow history

to see how long the process took add modified to the view

vba doesnt short circuit

here

"in" in access

in ssql server this

select * from

(select 1 as p union select 2 as p union select 3 as p ) as main

where p in (1,1)

will give you  1 row

in access - you will get 2 rows

sharepoint lookup threshold hit in access

set no caching in current database settings