GROUP BY

[fordy]

SELECT [Table1 Query].[STOCK VALUE], Max([NUMBER]) AS MaxDate
FROM [Table1 Query];
WHERE Group By [STOCK VALUE]

What I want is the most recent STOCK VALUE, from the last record, to be showed. But this doesnt seem to have worked. Can anyone help me

 

[RV]

It's either a WHERE clause or a GROUP BY command:

SELECT [Table1 Query].[STOCK VALUE], Max([NUMBER]) AS MaxDate
FROM [Table1 Query]
GROUP BY [STOCK VALUE];

Put always the ; sign AT THE END of a statement.
I don't know how your database has been designed. Try this, come back if you need further assistance.

Suc6,

RV

 

[fordy]

Im only a novice, is there any way in which you, only see the result of the latest query instead of it giving you all the records, thanks for your help