Recent content by isuruk

thank you.. will try this :)

thank u! will try n let you know how I get round this prob

Yes I realise that but I need that information returned to generate a report :( Is there another way to get round this prob? :banghead: PLs HELP

Can you pls look at the screenshot. This SQL is of that query

yes but access wont allow removing the grouping this is the SQL can you tel me how to improve it SELECT tblStudent.AgeGroup, tblStudentEvent.StudentID, tblStudent.FirstName, tblStudent.Surname, tblStudent.HouseID, tblStudent.Gender, Sum(tblStudentEvent.Points) AS TotalPoints FROM tblStudent...

Can you pls check the screeshot of my query and help me improve it? :confused::confused:

Well I am not sure how to do that. Can you pls advice further I have a eventresults table and the agegroup is in the participant table Points for individual event are stored in the eventresults table. I want to add the points of each participant and return the highest for each agegroup.

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:

sorry abt that

I have another question I want to create a query to find out the highest scorer for each event by adding points but the problem is how to aggregate only for each event. Access wont allow creating the query without using group by on all selected fields :(

thank u soo much very helpful :)

thank you soo much its worked! :) I used : MonthName(Format(Date(),"m"),False) for month and Format(Date(),"yyyy") for year :)

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...