Conditional Counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Your question indicates the counts are for other records (rows), not other
fields in the same row.
 
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.
 
Back
Top