G
Guest
I'm using the following. It produces the result I need.
SELECT Min([ID]) AS TheID, [Date], [Time], [UnderlyingSymbol]
FROM BTA_Trades_PIPs
GROUP BY [Date], [Time], [UnderlyingSymbol];
I have some other fields (Field1,Field2 etc) and would like them to be
displayed but do not want the result of the query to be altered from the
original.
Is it possible ?
Thank you in advance
SELECT Min([ID]) AS TheID, [Date], [Time], [UnderlyingSymbol]
FROM BTA_Trades_PIPs
GROUP BY [Date], [Time], [UnderlyingSymbol];
I have some other fields (Field1,Field2 etc) and would like them to be
displayed but do not want the result of the query to be altered from the
original.
Is it possible ?
Thank you in advance