database

[yiega]

hi guys,i have an access 2007 problem that i need help with...i am making a school database and i have reached a wall,okay heres the scenario.this school rewards the best performing students at the end of every term. The top 3 students in each class are awarded book vouchers whose values are as shown.on the tabel below.
i have a table with student details, a table with the schools "form" and an already calculated table of students marks,and average scores.so my question is,how do i make access to choose only the top 3 best performing students in each "form" and award them correctly with the book vouchers..plz help

class	postion 1	postion 2	postion 3
Form 1	1,100	900	600
Form 2	1,300	1000	700
Form 3	1,600	1,200	800
Form 4	2,000	1,500	1,000

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN

[yiega]

okay,june 7 i have seen the link but i guess that code is for sql,am not very familiar with sql codes. could i get may b an access link to the topN

[alansidman]

SQL is the language that drives the queries in Access. In the upper left corner when you are in query design view (QBE) there is a drop down. Click on it and it will show several options. Once is SQL. Copy and paste Allen's code into the SQL window. Amend it for your field and table names. Click on the design view to see in the QBE. This will help you to understand and learn some basic SQL. Also a good site to help understand SQL is at http://www.w3schools.com/sql/default.asp

[orange]

It appears to me that you may be more familiar with Excel than Access (based on your layout).
Do NOT confuse a spreadsheet with a database table.

There is no "Access link to TOP N". As Alan says -- it's SQL and the query by example screen has options to show the SQL.
Good luck with your project.