G
GE2V
As an experienced Access user I 've just started using v2007 and was very
surprised to see that an update query like this did not work...
update tableA set fieldX = "ABCD"
where exists
(select * from FindDuplicatesQuery F where F.Field1 = TableA.Field1 and
F.Field2 = TableA.Field2 and F.Field3 = TableA.Field3)
and FieldX is null
It updated the matches based on two of the fields rather than 3. I thought
my syntax was wrong so changed the update part to a "select *" clause and the
correct records were displayed. The FindDuplicatesQuery was based on tableA
and the three fields were those in the group by of the query.
Has anyone seen anything like this in Access 2007?
surprised to see that an update query like this did not work...
update tableA set fieldX = "ABCD"
where exists
(select * from FindDuplicatesQuery F where F.Field1 = TableA.Field1 and
F.Field2 = TableA.Field2 and F.Field3 = TableA.Field3)
and FieldX is null
It updated the matches based on two of the fields rather than 3. I thought
my syntax was wrong so changed the update part to a "select *" clause and the
correct records were displayed. The FindDuplicatesQuery was based on tableA
and the three fields were those in the group by of the query.
Has anyone seen anything like this in Access 2007?