DCount Expression

[Juddy]

Hi,

I'm quite a newbie to access so I'm probably making a simple error here but I'm struggling to use the DCount function when I've got a specific criteria, the result of the DCount I am displaying in a box on a form. I have tried various positions for the brackets, speech marks and even quote marks but the box just keeps displaying '#Error'. Once I delete the criteria section it displays the total. This is what I am trying:

=DCount("Cost","New Stock Totals","Physical Branch ='GRIMSBY'")

Thanks in advance for any help!
Kim

 

[pbaldy]

Because of the inadvisable spaces, try brackets:

=DCount("Cost","[New Stock Totals]","[Physical Branch] ='GRIMSBY'")

 

[Juddy]

Thank you so much that's perfect

I had tried adding various combinations of brackets but obviously hadn't found the correct one.

Thanks again!

 

[pbaldy]

Happy to help! Don't worry; it seems complicated at first, then it will all fall into place and seem simple to you.