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 I get it to look for the string as a whole. I am not using any wildcards, I have tried using within quotes
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 I get it to look for the string as a whole. I am not using any wildcards, I have tried using within quotes
