Hi
I am using a DCount function counting from a database/range
one cell in the range is called "Jersey Guernsey"
another cell is called "Jersey"
I am using criteria to count for Jersey and where it should count 1 it is counting 2 because it is picking up the Jersey from the first cell. How do...