User Profile

Collapse

Profile Sidebar

Collapse
armenperez
armenperez
Last Activity: Jan 21 '16, 10:02 PM
Joined: Jan 20 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • armenperez
    replied to Access query Distinct Row Count
    in Access
    I have added an id# that is autonumber.

    Entry Date Number ID# Count
    1/15/2016 30519 1 1
    1/15/2016 30519 2 2
    1/15/2016 30519 3 3
    1/15/2016 30519 4 4
    1/16/2016 12345 5 1
    1/16/2016 12345 7 2
    1/16/2016 12345 8 3
    1/16/2016 12345 9 4
    1/15/2016 34569 5 1
    1/15/2016 34569 6 2
    See more | Go to post

      Leave a comment:

    • armenperez
      started a topic Access query Distinct Row Count
      in Access

      Access query Distinct Row Count

      I have a query that I want the count to be incremental for each number with the same date

      Entry Date Number Count
      01/15/2016 30519 1
      01/15/2016 30519 2
      01/15/2016 30519 3
      01/15/2016 30519 4
      01/16/2016 12345 1
      01/16/2016 12345 2
      01/16/2016 12345 3
      01/16/2016 12345 4
      01/15/2016 34569 1
      01/15/2016 34569 2
      See more | Go to post
      No activity results to display
      Show More
      Working...