Don't know if this help, I am still learning myself, but when I am trying to write a SQL query, I usually just build a query in Design View in Access, make sure it works and then view the query in SQL View and copy that into a view in my SQL. As long as there aren't too many expressions in the...