I just tried this:
Code:
SELECT TestData.TestDate, TestData.TestNumber, Max(TestData.Data1) AS MaxOfData1, Max(TestData.Data2) AS MaxOfData2, Max(TestData.Data3) AS MaxOfData3
FROM TestData
GROUP BY TestData.TestDate, TestData.TestNumber;
- with the four rows of data from my first post.
It gave me what you said you were expecting.
See screenshots.
Let me know if this works for what you're trying.
P.S. This might fail if a test runs into another day.
I only used Date in my Date field - with Date AND Time . . . the grouping might not work.
But - you could decide to either NOT use the date field at all - OR - just use the Date portion of the DateTime value to group on.