How can I obtain the highest value from a column in the crosstab q

  • Thread starter Thread starter Guest
  • Start date Start date
Not sure what you are asking for,

To get the highst number you can achive by creating a query with Order
Descending

Select * From TableName Order By TotalFieldName Desc
=========================
If you want only the top record to be displayed add TOP 1 to the query

Select TOP 1 TableName.* From TableName Order By TotalFieldName Desc
==========================
If you want to get the Top record from a group by query, you can either
create the Order by in the query, or create another query based on the first
one, and get the max

SELECT Max(QueryName.FieldName) AS MaxOfFieldName
FROM QueryName
 
Back
Top