update query

[samotek]

I want to update the table field "Reminder "in the table TblClients with the entries in the field "Reminder" in the table tblClients1,but the update query does not give any results.What is wrong wih my query ?

UPDATE TblClients INNER JOIN TblClients1 ON TblClients.ClientID = TblClients1.ClientID SET TblClients.Reminder = [TblClients1].[Reminder];

 

[Golom]

Run this

SELECT T1.ClientID, T1.Reminder, T2.Reminder

FROM TblClients As T1 INNER JOIN TblClients1 As T2 
     ON T1.ClientID = T2.ClientID

just to be sure that there are matching records.

What is the datatype of the "Reminder" fields?