So which record(s) in that table should a query return? Based on what you posted, I'd say none. Expected/desired results are usually a good thing to include in your post(s).
EDIT - Or maybe it's 321,456.00, in which case try
Code:
SELECT Sheet1.amounts, Count(Sheet1.[id flag]) AS [CountOfid flag]
FROM Sheet1
GROUP BY Sheet1.amounts
HAVING (((Count(Sheet1.[id flag]))=1));
If your table has no id field, I don't think the results will prove to be too useful.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.