Prova a modificare la query da così:
SELECT Tabella1.nome, Tabella1.datacomp, Tabella1.scapesca, *
FROM Tabella1
WHERE (((DateDiff("\g","datacomp","scapesca"))<10));
a così:
SELECT Tabella1.nome, Tabella1.datacomp, Tabella1.scapesca, *
FROM Tabella1
WHERE DateDiff("d",datacomp,scapesca)<10...