Limit records meeting query criteria
Posted on 2012-04-03
I have an Access query but the difference with the limit I want to set compared to everyone else is that I want the limit after my criteria is met. Each person in my database might meet the criteria several times, but I only want to know the first time they do, after that I want the query to move on to the next person. Effectively I want one result per person. So what's the SQL limiting statement that comes after the WHERE statement, I don't think its LIMIT?