Recent content by earad

That worked; thanks

Hi Trevor, Thank you for the response. When I group by count it changes the column from the column of medical record numbers (ex. 102-302-369) into a 1; so when I set the criteria to >6 I get no data. thanks, Adam

Good morning, I have a query with about 17000 lines that shows me a date for each time a patient has seen his dr in a year. I would like to only see the patients that have seen the doctor 6 or more times. the unique data to each patient is thier medical record number. Thanks in advance...