J
Jim/Chris
In a new control in a report
=Sum(Abs([fieldname]="yourvalue"))
In a totals query
Total:Sum(Abs([fieldname]="yourvalue"))
Jim
how to total numbers, but not how to count the number of
times a word appears. I've tried using a report and a
query, but I can't figure out a way to count text.
=Sum(Abs([fieldname]="yourvalue"))
In a totals query
Total:Sum(Abs([fieldname]="yourvalue"))
Jim
are used in a column of my Access table. I can figure out
how to total numbers, but not how to count the number of
times a word appears. I've tried using a report and a
query, but I can't figure out a way to count text.