Hi, I need help with very basic Microsoft Access Queries, I been given a database with one table, that has student name, suburb, gender, IT Mark and Maths Mark. (and a few others). I need to do the following queries.
1. Display the average Total Mark for each suburb. Sort by ascending Suburb. (total mark is the IT + Maths Mark)
2. Display the highest IT mark for each suburb. Sort by ascending suburb.
3. Display the highest Maths Marks for females.
4. Display the average IT mark and the average Maths Mark.
I would like to email you the database and if you could make the queries and send it back it would be most easiest for me to learn the expressions you used. ([email protected]) is my email
saved as 2003