First, we need to get the query returning data.
What data type are the fields [FP (Dep)], [FP (PTSD)] & [FP(Both)] ??
What data type is the field [Suicide Risk]? (Sample data?)
Does the field [Suicide Risk] really contain the word "blank"?
Code:
WHERE ((Not ([Monthly %].[Suicide Risk])="blank"));
If there is nothing entered, it might be Empty or Null. You cannot test for Empty or Null using "blank".You might try
Code:
WHERE Not IsNull([Monthly %].[Suicide Risk]);
BTW, "Month", "Day" & "Year" are reserved words in Access. They are also functions. Using "Month", "Day" or "Year" as field names will cause you to bang your head against the wall....
In addition, they are not very descriptive. "Month" of what? DOB, Lunar phase?
Names of objects (fields, tables, queries)also should not have spaces. Nor should you use special characters / , & , () , %
(Underscores "_" are OK.)