First let me point out that this is a repeat of multiple stack-overflow questions that all have answers - yet none of them solve my problem

For instance - these two:
[Access join on first record](https://stackoverflow.com/questions/6128351/access-join-on-first-record)
and
[How to select top 10 in Access query?](https://stackoverflow.com/questions/9339079/how-to-select-top-10-in-access-query)

---

My problem should be simple - but - the obvious answers are not working.

I have two tables. Client and Transactions.

I want to return a list of clients with the last sale date.
Easy right....
Select the columns for the client and then for sale date do a subquery that limits the return to 1 item.

```
SELECT 
[Client].[LastName] as C1,
[Client].[FirstName] as C2,
(SELECT TOP 1 Transactions.SaleDate FROM Transactions WHERE Transactions.ClientID=Client.ClientID  ORDER BY Transactions.SaleDate Desc) as C3,
[Client].[ClientID] as C4
FROM [Client]

```

BUT access is telling me that the subquery has this problem:
"At most one record can be returned by this subquery."

Ah... but stack overflow has an answer to the 
"At most one record can be returned by this subquery." error.

--->"Your subquery is returning more than one result."
"Try fixing the data using select top 1"

[At most one record can be returned by this subquery. (Error 3354)](https://stackoverflow.com/questions/21529485/at-most-one-record-can-be-returned-by-this-subquery-error-3354)

well... Great.

Is there something else in the SQL that could be confusing it that I am totally missing?