Error with query 1

[Niebotel]

thread701-1691734
UPDATE Ontvangsten
SET ID = DCount("*","Ontvangsten","IDIn<=" & [IDIn])
did work in the past but now it fails on another table:
UPDATE [Kopie van Passanten]
SET ID = DCount("*","[Kopie van Ontvangsten]","IDIntern<=" & [IDIntern]);

When the query runs it dais that it could not chage the field because of:
I translate:
BECAUSE OF ERROR IN CONVERTING THE TYPE
Because I do not completely undertsnd the query Ii is difficult for me to find a solution.

Can you explain or help?

 

[dhookom]

I plan on a great day and evening since today is my birthday ;-)

Duane
Hook'D on Access
MS Access MVP