Need to query maximum number in hour per day every cell ID

[lotto009]

Dear All
I need to know about "Need to query result from access2007 find only "one maximum number" in hour per day every cell ID"
How I use sql command


you can see my file att
Thank you verymuch

[June7]

Your requirement doesn't make sense to me. The sample data has 73 records, grouping by date, hour, UCellID returns all 73. What records do you want the query to retrieve?

[lotto009]

Dear June
So sorry for my requery I just mean
-how to query "SHO overhead" from a day find looking for maximum value in a list of cell id
-because have 1 day have 24 Hour ,have many Cell ID
-I am begin for access
-have more suggestion can to do
best regards

[orange]

??? I don't understand the post either.

Hour and Date are reserved words in Access.

"Need to query result from access2007 find only "one maximum number" in hour per day every cell ID"????

Suggest you give a sample -- show us some raw data, and the result you want.

[lotto009]

I would like keep result
-One Maximum number in a day from hour
-Than any cell ID list must be have one maximum number per day
-In my file have many cellID I can not find result
Could you advisor I att file as below photo
Thanj you

[orange]

Since all of your records have the same Date, there is no need to group by Date.

I still don't understand the post.

Here is a query to get MAX([SHO Overhead]) by Hour

SELECT Data1.Hour, Max(Data1.[SHO Overhead]) AS [MaxOfSHO Overhead]
FROM Data1
GROUP BY Data1.Hour;