Conditional Counts

W

WillW

I need conditional Counts on my form - that is, counts that are dependent on
values in other fields on the row (record). Examples:
Count(# rows where ReviewId = 10)
Count(# rows where AdherenceInd = "N" and ArtifactId = 100)

I had hoped to use text boxes with some combination of Count and conditional
functions in Control Source - but I'm open to any (not-to-difficult)
suggestion.

Thanks in advance
 
M

mscertified

Your question indicates the counts are for other records (rows), not other
fields in the same row.
 
W

WillW

Thanks. Guess I wasn't very clear.

I have a returned set of records in a form, and I need to get rowcounts
based on values of fields in the rows.

I've been trying to store the values in text boxes by using Expression
Builder (Count, Dcount, etc) but can't make it work.
 
Top