Counting instances in query

  • Thread starter Thread starter Nyrubi
  • Start date Start date
N

Nyrubi

How do I setup query to count instances on table. I have many rows of
claims. There are many fields but I need to narrow it down to ID, start
date. I need to find 2 instances for each member. thank you.
 
How do I setup query to count instances on table. I have many rows of
claims. There are many fields but I need to narrow it down to ID, start
date. I need to find 2 instances for each member. thank you.
Click to expand...

Please explain with an example of your existing data and desired output. Your
question is ambiguous - my guess is that you have multiple dates per ID and
want to retrieve only two of each ID, but you give no indication of WHICH two.
Or you might be meaning something else entirely!
 
Back
Top