Access assumes anything it doesn't recognise is a paramater. If it's asking for UpdatedTime then one of the references to UpdatedTime in your query is incorrect. In the query you posted last you reference UpdatedTime 3 times and every time it's from the TradingSummaryStatus table. That leaves 3 possibilities:-
1. There is no UpdatedTime field on the TradingSummaryStatus table
2. The field name is miss-spelt
3. You're not running the sql you've posted here.