Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    34
    Provided Answers: 1

    Answered: Show ID only if it appears 3+ times in a query

    I have a query that shows which kids have been absent in the past three weeks. But really I only need to know if they have been absent three times in that amount of time. It isn't a huge deal to scan down the list to see who has three entries, but it would be great if there were a way Access could show me only those entries that appear three times. Is this possible? Or too complicated? Thanks!

  2. Best Answer
    Posted by healdem

    "Depends on your table design
    but have a look at using the count function within SQL"


  3. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Depends on your table design
    but have a look at using the count function within SQL
    I'd rather be riding on the Tiger 800 or the Norton

  4. #3
    Join Date
    Oct 2014
    Posts
    34
    Provided Answers: 1
    Got it, thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •