A question regarding counting and sorting based on criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This may be better suited to Excel but here goes. I have a database of
newspaper subscribers. They need to be divided into two groups based on
their street address and both groups counted based on how often they receive
a paper (sunday only, daily & sunday, saturday & sunday only, etc). I am
very much a novice but this seems so simple yet beyond me. Thank you so much
in advance!
 
Assuming a table with field including Street, Schedule (how often delivered)
and SubscriberID, the following query would do it ...

SELECT tblTest.Street, tblTest.Schedule, Count(tblTest.SubscriberID) AS
CountOfSubscriberID
FROM tblTest
GROUP BY tblTest.Street, tblTest.Schedule;

In case you're not familiar with SQL, here's how the same query looks in
design view ...

http://brenreyn.brinkster.net/query3.jpg
 
Back
Top