Search results

I urgently need help in this I have attached a screenshot of the query I created to total points for each competitor and them I want the query to return only the highest for each agegroup. But I dont know how to do it. :banghead: :banghead::confused:

Hi I need urgent help. I have a query searching a database which stores the month and year in text. I use Monthname(DatePart("m", Date),False) to get the current month name and Datepart("yyyy", date) to get the current year for corresponding text fields. But the query gives a data type mismatch...