My Table: ShortagesDB looks like this:
TopLevel mFirstOut FC1114 5/1/2020 FC1114 1/1/2021 FC1114 8/1/2020 FC1114 5/1/2020 FC1114 5/1/2020 FC1114 2/1/2021 FC1114 6/1/2021 FC194 6/1/2021 FC194 2/1/2021 FC194 6/1/2020 FC194 8/1/2020 FC194 5/1/2020 FC194 1/1/2021 FC1Corgi68 8/1/2020 FC1Corgi68 4/1/2021 FC1Corgi68 5/1/2020 FC1Corgi68 5/1/2020 FC1Corgi68 5/1/2020 FC1Corgi68 5/1/2020
I want to display only the first occurrence of each top level
TopLevel mFirstOut FC1114 5/1/2020 FC194 6/1/2021 FC1Corgi68 8/1/2020
Created a Query
TopLevel mFirstOut
First Group By
And I get this not sorted properly:
TopLevel FirstOfmFirstOut FC1114 5/1/2020 FC194 6/1/2020 FC41212 7/1/2020
The sql statement is
SELECT First(Shortagesdb.TopLevel) AS FirstOfTopLevel, Shortagesdb.mFirstOut
FROM Shortagesdb
GROUP BY Shortagesdb.mFirstOut
So I put an Ascending Sort on the TopLevel
TopLevel mFirstOut
First Group By
Ascending
And I lose my grouping entirely
SELECT First(Shortagesdb.TopLevel) AS FirstOfTopLevel, Shortagesdb.mFirstOut
FROM Shortagesdb
GROUP BY Shortagesdb.mFirstOut
ORDER BY First(Shortagesdb.TopLevel)
Are ORDER BY and FIRST( mutually exclusive?
Do I need to use 2 queries?