Parameter value

Question

SELECT ID, AppID, Description, Min([Transaction Date]) AS TransactionDate
FROM AppProsHist
WHERE [Description]='Non-Final Rejection'
GROUP BY ID, AppID, Description
ORDER BY TransactionDate DESC 

I keep getting the "Parameter Value" field for "TransactionDate". Does anyone know how I can leave?

Answer 1

TransactionDate is an alias for expressing a field Min([Transaction Date])

Access does not accept an alias ORDER BY. Any of these two alternatives should work ...

ORDER BY Min([Transaction Date]) DESC
ORDER BY 4 DESC