Recent content by Pippa_McC

Re: Showing 0 if no results (Solution) Hi, I know that this thread was from last year however, if anyone else is having the same issue, heres another fix: Write your query as normal to count the number of occurences & save. Open your form in design mode and click on your text box & open...

This worked for me too. Thanks so much BMiles13! This has been bugging for for longer than I care to mention :D