I have had problems using a column in a query that is an expression (like [TenthIC50]) in another calculation (TenthCount). Apparently Access does not recognize the name of the expression/calculation in the other calculation.
You have something like:
Code:
TenthCount: DCount(field, domain, "AvgIC50 <= " & [TenthIC50]
Try changing it to
Code:
TenthCount: DCount(field, domain, "AvgIC50 <= " & ([mIC50] * 0.1)
I couldn't read the expression in blue from the attached picture..... Hope you get the idea.
--------------------------------
Another way is to save the query "qryTKSAcba" (I think that is the name of the query) without the column "TenthCount".
Create a new query, adding the query "qryTKSAcba" and dragging down all of the fields.
Now add the new column
Code:
TenthCount: DCount(field, domain, "AvgIC50 <= " & [TenthIC50]
Because "[TenthIC50]" is now a "field" in the saved query "qryTKSAcba", the "TenthCount" should now work.