Easy query

[colinmunnelly]

Can anyone help me with this. Im sure im missing something really simple.

I have 6 text boxes in a table. In each text box there can be one of a possible 5 leters ie. "AI" or "A" or "NR". i need to make a query to count how many "A"s are in my database and how many "AI"s etc. I have tried using the count symbol in the query design view but gives me a type mismatch message. I need this information to form a pie chart. Is there a simple way of doing this.
Any help would be appreciated

Col

 

[Hayley Baxter]

Hi Col

Select totals on your query group by your field name

First column in your design grid would be your field name then under this group by. 2nd column your field name count and criteria count(*)

I just tested that for you that should work

Hay

 

[colinmunnelly]

can you please explain a little more clearly. Thanks alot
C

 

[Hayley Baxter]

What's your email and I'll send you a demo.

Hay

 

[Hayley Baxter]

sample

Col

I think this is what you are attempting to do. If not please let me know.

Hay