How can I count how often information recurs in my database?

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

Guest

My company uses an SQL database to record the passenger pickups we make. Can
anyone help me get started building an Access query that will tell me how
often a certain address is visited?
 
My company uses an SQL database to record the passenger pickups we make. Can
anyone help me get started building an Access query that will tell me how
often a certain address is visited?
Click to expand...

Well, not without knowing a bit more about the structure of the
data... but a Totals query grouping by Address and Counting the
primary key would be a good place to start.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top