Expression query based on same criteria

Expression query based on same criteria

I don't know how to explain this in a few words so I don't know how to
search for it. I'm sure someone must have asked this question before but I
can't find it.
I'm trying to use an expression query where the criteria are identical. I
want to find total production by city but my production information comes
from stores. There could be 500 stores in 300 cities. Some of those cities
could have one store and some could have five.
The only way I can find to do this is to actually type each city into the
criteria field. There must be a way to tell Access to add where certain
criteria are IDENTICAL but I can only find operators. I feel like there is
probably a super simple solution but I have been working on this for three
hours and still can't get it to work. Any help is appreciated!