Multiple Column Count Query

[clayt101]

I am hoping that you all can help me. I have several columns of text data. Each column contains the same text variables (I think that there are a total of 10 text entries).

Anyhow, is there a way to do a count query on all the columns at the same time, just giving me a total of each time the variable comes up regardless of which column it is in?

I know that I can solve this by appending all of the columns into one column and then doing a simple count query, but I imagine that there must be a more "proper" way of doing this.

Thanks in advance.
Clay

 

[jbeaucaire]

COUNTIF() works on multiple columns.

=COUNTIF(A:G, "cat")

 

[boblarson]

Is this an EXCEL question or an ACCESS question, because it is in the Access category but perhaps it should not be???

 

[jbeaucaire]

Doh, my bad, it does indicate a query, my apologies for the EXCEL answer.

 

[boblarson]

It is actually easier in Excel than in Access. In Access it would either be using the method that the OP suggested about the concatenating of the fields together or by creating a large Union Query unioning them all together so you can get the count that way. It sounds like it might not be normalized data, but hard to say.

 

[clayt101]

COUNTIF() works on multiple columns.

=COUNTIF(A:G, "cat")

Thanks. I was not aware of that solution method. I never knew that there was away to do the count query in excel. I will play around with it on Monday. I enjoy playing around with access, but I really do not know how to do any of the advanced stuff.

Thanks again,
Clay