? to construct a complex DAO query

[CharlesWhiteman]

I'm trying to convert the following query and use DAO, can anyone ploint me in the right way in constructing the same but using DAO, or suggest the/another best way?

INSERT INTO TblRadAcctLocal ( RadAcctId, MacAddress, FramedIPAddress )
SELECT Max(radacct.RadAcctId) AS MaxOfRadAcctId, TblRads.MacAddress, radacct.FramedIPAddress
FROM TblRads INNER JOIN radacct ON TblRads.MacAddress = radacct.UserName
GROUP BY TblRads.MacAddress, radacct.FramedIPAddress;

 

[CharlesWhiteman]

Basically i am trying to get around an issue where when the query is opened using access runtime version the application halts. If I run the query in VBa instead would that get around the issue?

 

[Guus2005]

This guy might know the answer!

HTH