record count revisited attn: Tom Ellison

S

Sasha Furr

I was away from the computer until today, which is why the
delay in my reply.


the query I need to sort/rank records in is:

SELECT OnHandSummary.ItemNumber, OnHandSummary.Descriptio,
OnHandSummary.GLClass, OnHandSummary.Product_Line,
OnHandSummary.[Inventory Type], OnHandSummary.[12Usage],
OnHandSummary.[12Usage$], OnHandSummary.AvgOfQty,
OnHandSummary.[Avg$], OnHandSummary.StDevOfQty
FROM OnHandSummary
ORDER BY OnHandSummary.[12Usage$] DESC;

thanks!!!
Sasha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking records in sorted list based on expression 7
Access errors out when query by ascending 1
Ranking the records. 2
More questions for Tom Ellison 8
Count and order by - error 2
Count issue continued from "text then date ascending count" 8
Slow Query 4
Avg, AS, GROUP BY query 1

Top