Thanks. I split the query into a select and an append and it works OK now.
"Mattias Jonsson" <news[ at ]ett-remove-idesystem.se> wrote in message
news:u$Zk8YViGHA.4580[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > Bill,
> I don't think you can use DISTINCTROW with this update query.
>
> Good luck,
> Mattias
>
> From: Bill Cart, on 6/5/2006 7:51 PM:
>> I have an update query:
>>
>> UPDATE DISTINCTROW (ClientNotExistWork LEFT JOIN
>> LCAClient_TblGroupedClients ON ClientNotExistWork.LcaId =
>> LCAClient_TblGroupedClients.ID) RIGHT JOIN WellnessClientStartDates ON
>> ClientNotExistWork.ClientId = WellnessClientStartDates.ClientID SET
>> LCAClient_TblGroupedClients.[Well ID] =
>> WellnessClientStartDates!ClientID, LCAClient_TblGroupedClients.[Well
>> StartDate] = WellnessClientStartDates!StartDate,
>> LCAClient_TblGroupedClients.[Well EndDate] =
>> WellnessClientStartDates!EndDate
>> WHERE (((WellnessClientStartDates.ClientID) Is Not Null) OR
>> ((WellnessClientStartDates.StartDate) Is Not Null));
>>
>>
>> I can preview the data in DataSheet View but when I try to run the query
>> I get an ODBC error about an invalid argument (#0). Any ideas on what
>> might cause this?
|