I have a table with a field on each record containing path's til files on my disk.
I wants to know if more than 1 record "points" to a file I want to delete - so I use the DCount() but it counts wrong !!!!
In my immidiate window I do a DCount() for a specific filepath - and it SHOULD return 2 (the last 2 in the table !), but it returns 5 - see my attachment !
What it wrong here ?