Hi All,

I have problem with query acces. I have created query from acces query
design. But I got difficult to implemented this query to vba macro.


SELECT tabel2.tgl, tabel2.num, tabel1.dates,
abs(tabel2.tgl-tabel1.dates) AS ddif
FROM tabel2 INNER JOIN tabel1 ON tabel2.site = tabel1.site;

this query i save with name query1

SELECT query1.dates, min(ddif) AS [min]
FROM Query1
GROUP BY query1.dates;

that query i save with name query2

how to implemented that query to vba macro. tabel2 should be variable.

(tabel2 must be changed to tabel1,tabel2, tabel3 etc...) ?

Thanks

Ardi