Solved Group by (1 Viewer)

[Anetal]

I have a problem. I have two identical ids which should merge into one when using a query with group by. Unfortunately it does not work. How to remove invisible characters in an access file and make them fold?

 

[arnelgp]

create this query and run:

update tabelka set [claim number]=replace(replace([claim number], chr(10),""), chr(13), "")

now run your Total query.

or in VBA, immediate window:

currentdb.Execute "update tabelka set [claim number]=replace(replace([claim number], chr(10),''), chr(13), '')