A
Ayse via AccessMonster.com
I am trying to come up with a percent on 2 text fields. I have two text
fields [Insurance] and [Diagnosis]. I need to know what percentage of the
total come from each different type of Insurance and each different
Diagnosis. I created a Qry with the Group By then Count funtion but since
my fields are text I don't know what to do to come up with the avg.
fields [Insurance] and [Diagnosis]. I need to know what percentage of the
total come from each different type of Insurance and each different
Diagnosis. I created a Qry with the Group By then Count funtion but since
my fields are text I don't know what to do to come up with the avg.