I have the following DCount code:
Code:
TenthCount: DCount("[AvgIC50]","tblDataCBA","AvgIC50 <= " & ([mIC50]*0.1))
This code applies to this query output:
Which was constructed as follows:
The issue is that the query output includes the entire field filtered by the TenthCount expression. However, I want the count further filtered by individual Compound, so I need my expression to include reference to the primary key (comprefinvPK). However if I revise the above code to this:
Code:
TenthCount: DCount("[AvgIC50]","tblDataCBA","AvgIC50 <= " & ([mIC50]*0.1) And "[comprefinvPK]=[comprefinvFK]")
Then it simply returns the record count for a subset of the AvgIC50 field (7506), which is obviously not what I'm looking for (not even sure what its calculating - I'm only showing a subset of the query output). Can someone please help me figure out this last bit of syntax? This has been dogging me for three days and I think I'm close to the end of the tunnel, but need to make it past this final bend.