Update SQL Table w/Access Query

[CptTom]

I need to update a MS SQL Server Table with data from MS Access. In SQL Server it would look something like:

Update Master
Set Reported to 'Yes'
From Master
Left Join (Select Distinct UIC, DateReported from NMC_Detail Inner Join CurrentInfo On CurrentInfo.ReportDate = NMC_Detail.DateReported)


The Master Table is in SQL Server, the other 2 are in MS Access. This is a temp fix, since I am moving everything to SQL Server before the end of year.

However, MS Access will not let me run the distinct (or grouped) command and the query itself still be updateable.

CPT_TOM