I am working on a project that needs me to count occurences. I am not sure how to do so. I tried DCount but cannot get it to work. Below is a sample of what I am trying to do.



Query

Zip Returns
11111 52
22222 100
33333 45
11111 100
11111 50
22222 28
33333 26

I need to know how many times (occurences) each zipcode has had >0 and <50 returns

the end result would look like this:

Zip Returns >0 and <50
11111 2
22222 1
33333 2

I think I need to do an expression but am not certain.

Like I said, this is a sample table of what I am trying to do. The real table has 222000 zipcodes, many repeated.

Please advise!!!! also, please make it as simple as possible. I am not very familier with access.