Trying to get one record

[AccessSHELL]

I have a table with the followings columns:


Year, Month, Day, mics info.
I am trying to write a query where I get one one record. The requirements is that the record is lowest year number. In my attempts I get just one year, but with several records. It happens to be the same number of records for that lowest number year.

Can someone advise me what I am missing?

Thanks

[CJ_London]

without knowing what you are trying, can't say what you are missing

Year, Month and Day are all reserved words and should not be used for field names

best I can suggest is

SELECT min([Year]) from myTable

if this does not solve the problem, provide example data and the result required from that example data

[AccessSHELL]

Works great. Thanks