My Query seems to default to the SQL view and cannot be view in the Design View and hence giving an error message when I tried running the query. The error message is some kind of 'the name of the query not valid etc
-
-
Some queries cannot be viewed in design mode, as there is no graphical way to represent them. Union queries come to mind, there may be others.
It could be there is a mistake that makes the sql look like something that cannot be presented in the designer mode. You're going to have to read carefully through the SQL to find the problem, or start over, hopefully avoiding whatever mistake was made the first time.
Taking the error message at face value, there may be a misspelling of a query name in the SQL, or maybe some query that this query was using has been deleted. That seems pretty likely to be the culprit, to me.
Jim
Comment