=count subform + filter again..Help

[memaxt]

Hi All,

I'm having a right time trying to figure out the following.

I have placed a text box in a subform with the following:

=count([Risk Rating])

and a textbox in the main form =[QryRisk_Subform].[form].[Red]

I'm trying to filter =count([Risk Rating]) again by adding "Red" at the end

=count([Risk Rating]) = "Red"

So I can get a count for Red, Amber, Green

I'm guessing i've tryed the formula wrong or is the above even possible?

Many thanks
Max

 

[memaxt]

Apologies for the post, I found the answer on here..I did a bit more digging using the search

Formula I used in the end:

=-Sum([Risk Rating]="Red")

*Note "-" next to = to avoid having a negative value.