I am trying to build a query that shows the count of items sold, based off certain zip codes, based off of date sold. This is the query SQL I am using:
Code:
SELECT COUNT(data.ID) AS [Count], salesRepName
FROM data
WHERE data.ZIP = "12345" OR data.Zip = "444444" OR data.Zip = "66666"
AND data.SOLDDATE BETWEEN #01/01/2013# AND #04/01/2013#
The issue I am running into is it is returning a blank query. I want it to show for example sake --
0 Mark Jones
0 Richard Javier
How should I set up my query to show this?