Count then Avg in Query on text field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ayse - 06 May 2005 14:24 GMT

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.

Reply to this Message

jl5000 - 06 May 2005 23:58 GMT

Could you show the table structure, sample data, and how do you want the
results to show?

like
Table(Field1,Field2,...)

Field1 Field2...
data1 data2
data1 data3
data4 data5

Results
data1 67%
data4 33%

Signature

jl5000
<a href="http://joshdev.com"></a>

> 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.

Reply to this Message