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

[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?

 

[John Spencer (MVP)]

See reply to your earlier post.

 

[John Vinson]

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?

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