Counting multiple fields 1

[dmoran]

I'm drawing a blank for what I'm sure is an easy solution -
I have a report where each record has 5 fields labeled "med1" through "med5". These 5 fields may/may not contain the name of a medication. All I want to do is display a total count of entries in the report footer for all meds entered.

Thanks,
David

 

[hymn]

try placing 6 text box in the footer 1 to 5 as below
=Abs(Sum([med1]))*5
then the sixth a total field summing the other 5
but there must be an easier way

Hope this helps
Hymn

 

[dmoran]

Thanks for your response hymn - that was my initial thought too. It works, I'm using "Count" instead of "Sum" though because of the text values.

David