How Can I Do This

[ecuevas]

How can I make a querie that finds the ten most expensive items in my table?

 

[chergh]

SELECT TOP 10 field1, field2
FROM TableName
ORDER BY PriceField DESC

 

[ecuevas]

I don't really understand what you are trying to say. This is what I have so far:

Field: Cost
Table: TBL-Inventory
Sort:
Show: Checked
Criteria:
Or:​

What exactly would I type in?

 

[chergh]

SELECT TOP 10 TBL-Inventory.cost
FROM TBL-Inventory
ORDER BY TBL-Inventory.cost DESC

Your also going to want to include the field with the name of the item in this.

 

[ecuevas]

It didn't work. I might have typed it into the wrong place. I put TOP 10 TBL-Inventory.Cost as the field. I also tried putting into Table but that didn't work either

 

[chergh]

Right click on the title bar and select "SQL view" and then copy and paste the text.

 

[ecuevas]

Should I put it at the end?

 

[chergh]

No delete what is already there and replace it with what I have written

 

[ecuevas]

It says "syntax error in FROM clause" when I try to close it.

 

[chergh]

Try this:

SELECT TOP 10 [TBL-Inventory].cost
FROM [TBL-Inventory]
ORDER BY [TBL-Inventory].cost DESC

 

[ecuevas]

It works but now I can't see any of the other fields.

 

[chergh]

Just go back to the design view and add the fields you need back in.

 

[ecuevas]

It works now. Thanks for the help.

 

[Bratlien]

Nice crash course in SQL.