Like condition for 1 column help pls!

[stodd]

Hello everyone!

I have access database and i'm trying to make a query using the like condition in it. I've added 1 column 2 time in the query and i'm trying to use the like condition to pull 2 different things.

In this column are just 1 Letter A, B, C, D, E. There are locations linked to each letter in a different column of the database. The first thing I'm trying to get with the like condition from the column is the letter "E". Then i've added that same column in the query again and want to pull everything that has the letter C in the column. And i need the data to output in that column only. But what it is doing for me is putting the data for the "E" and the "C" in the same column after i do the query.

I need the output to be in the first column the location, then second column I need to the show the letter "E" (but count that and show me a number of times it comes up with that letter for that location) and then same thing for letter "C" in the third column ( but count this one too and show me a number). So when its done ill have 3 columns of information 1 listing the locations, 1 listing letter "E" numbers and 1 listing letter "C" numbers.

If anyone out there can help me with this problem i'm having that would be great! I'm getting heat from my bosses to get this data.

Thank you so much!
Shane

[ConneXionLost]

Hi stodd,

You did not provide a source table or field names so it is a little difficult to provide an answer, but this might help:

SELECT yourtable.Location, Sum(IIf([lettercolumn]="C",1,0)) AS CCount, Sum(IIf([lettercolumn]="E",1,0)) AS ECount
FROM yourtable
GROUP BY yourtable.Location;

Cheers,