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.