Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Can Access 03 count instances of an entry?


  • Please log in to reply
1 reply to this topic

#1 DnDer

DnDer

  • Members
  • 646 posts
  • OFFLINE
  •  
  • Local time:12:00 PM

Posted 27 July 2009 - 03:55 PM

I've been googling, but haven't been able to find what I want - one way or the other.

I've built a database of people by state. So I have column A for NAMES and column B for STATE. How do I get Access to break down how many instances of ILLINOIS or NEW JERSEY (or all of them) and then publish it on a report?

BC AdBot (Login to Remove)

 


#2 DnDer

DnDer
  • Topic Starter

  • Members
  • 646 posts
  • OFFLINE
  •  
  • Local time:12:00 PM

Posted 27 July 2009 - 04:11 PM

And is there a way to generate a report based on only a portion of that data? Say I want to generate a report not for STATE, but only for entries that have ARIZONA in the STATE column?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users