I am doing some ICT coursework and I a bit stuck.

I am creating a database that will allow users to log in and submit bids on houses. There are only a certain amount of house plots available, but I cannot seem to make the database find the top bidders within the plots available, for example the top 5 bidders or top 7 bidders, depending on how many plots available.

I have 4 fields, from two different tables. I have a bidder ID field, House Type ID field (which I use "[please enter house type ID"]), a bid amount field and Number of plots field.

I want the query to select the top "x" amount of bids that it says in the number of plots field, e.g. 5.

How can I do this for all the different house types?

In query design when you right click and open the query properties window there is a 'Top Values' setting that you sshould be able to use to do this. If you put the cursor on the 'Top Values' line and press F1 it should bring up the help dialog.

Each house type has a different amount of plots, so using the top value setting will only work for one of the house types.

Would I have to use a different query for each house type?

Any ideas?

The terminology has me a bit confused. Can you post a sample db with what you have for tables, etc?