Is DCount() counting wrong ?

[ksor]

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 ?

[ranman256]

Is [pinpointer] field a memo field?
you can't query on memo fields.

[ksor]

Is [pinpointer] field a memo field?
you can't query on memo fields.

No, it's a text-field

[andy49]

Is my eyesight going or is the name of your field different in your Dcount from in your table

[AccessPower]

Your eyesight isn't wrong. one has underscores, the other has spaces.

[ksor]

Is my eyesight going or is the name of your field different in your Dcount from in your table

That part MSAccess maneges itself - I did NOTHING when typing the names ... I think it's called "intellisense" ... it presents the names itself - right ?

EDIT:

But in the criteria section I have to use the actual field name NOT the access interpretation of it !

I have changed the code so the field ONLY contains the file NAME, path NOT included !

This here counts right :

? DCount("*", "STED","[Sti til PinPointer-fil] = 'Hasle Sogn.kmz'")
2

NICE !