User Profile

Collapse

Profile Sidebar

Collapse
trakker
trakker
Last Activity: Jul 10 '07, 05:41 PM
Joined: Jun 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • trakker
    started a topic Distinct Count Multiple Fields
    in Access

    Distinct Count Multiple Fields

    Hi I'm trying to return a count for distinct value for 2 fields. So for example

    1 2
    bat hat
    book store
    bat hat
    book room
    dark room
    bat hat

    I would want it to return the Number 4 because there are four distinct combinations

    Thanks
    See more | Go to post
    • trakker
      replied to Count of two different values in the same field
      in Access
      Thanks for the reply.

      Sorry I forgot to mention that I need the values to appear in their own column.


      So if the number 1 appeard twice then I would need a column named Number of #1 Occurences with the value 2 and if the number 2 appeared 5 times then I would need a column named Number of #2 Occurences with the value 5.
      See more | Go to post

        Leave a comment:

      • trakker
        started a topic Count of two different values in the same field
        in Access

        Count of two different values in the same field

        How do I go about doing a count on a column called BT for two different possible values? For example if

        BT= 1
        BT=2
        BT=1
        BT=2
        BT=3
        BT=1

        How would I count the number of times BT=1 and BT=2?
        See more | Go to post
        No activity results to display
        Show More
        Working...