DCount and Report text box

[chrisvt]

I'm creating a report that uses a query for its Record Source. The name of the query is ProjectStatus and it contains three fields: ProjectName, Classification, and Ranking. There are approximately 60 records in the query and each record has a Ranking of either Open, Closed or Pending. I have a text box on my report and am trying to program it to show the number of projects that have a ranking of Pending. I think I should be using DCount to accomplish this, but I'm getting an error. In the Control Source for the text box, I have the following:

=DCount("Ranking","ProjectStatus","Ranking=Pending")

Am I missing something obvious?

 

[bob fitz]

Try;
=DCount("Ranking","ProjectStatus","Ranking='Pending'")

 

[chrisvt]

Perfect! Thanks, bob! I knew it was something simple.