Count then Avg in Query on text field

  • Thread starter Thread starter Ayse via AccessMonster.com
  • Start date Start date
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.
 
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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Percentage on Text Field 2
Count text values in a Access Field 0
Query with total count 3
Nested SQL Statements causing slowness and errors 7
Linking Table Fields??? 1
Count unique field1 combined with count field2, both grouped andungrouped 3
Creating query based on no-match 6
Query of multiple fields containing similar data 1

Back
Top