filtering to display one entry per row

[GarageFlower]

im running a query on a table which contains many entries for the same thing
the many entries are different years finanical information for that project
how can i get a query to display a projects total spending for its earliest year, and not display any other year for that project
bare in mind each project could have a different earliest year

 

[Samoan]

This may work for you:

Select your_columns
from table1 A
where A.date =
(select min(B.date)
from table1 B
where A.project = B.project)

 

[GarageFlower]

thank you but not realy enough instructions for me to implement.

could you upload an example please or include more detailed instructions

Many thanks