Hidden SQL Statements

[Tuckejam]

I'm learning access and have been mimicking queries from the Northwind database



If you duplicate the "10 most expensive products" exactly as it shows in design view, it does not operate the same as the original query in the NorthWind database

(after tearing some hair out) I found this is because in the SQL view there is an extra "TOP 10" added to the SQL statement.


A. is there a way to create a "TOP 10" query using just the design view? meaning not having to manually enter the SQL "TOP 10" statement?


B. is there a way to tell when a query has been edited or added to using SQL that can not be generated in the design view?

Thanks for any thoughts or help

[ranman256]

A. yes, put it in design view then set the TOP property.
B. no. well,except union queries. but you could hide the query so they cant see or edit it. set visible property = no.

[pbaldy]

There are also certain joins that can't be represented in design view (non-equi join comes to mind). It may help to think of design view as a GUI that makes it easier to create/maintain SQL. SQL is what the database engine actually uses, not design view.

[isladogs]

As already stated, Union queries and non-equi joins can't be displayed in design view.
Nor can passthrough queries or data definition queries.

Unless I've forgotten something, all the many other query types can be done in either design view or SQL view

[Tuckejam]

I think my question was really just....

Do all queries that can only be done in SQL view show up with a special Icon, Like the union query does.
(or is union the only query that cant be done in design view)

[pbaldy]

No, append, update, delete, and passthrough queries all have different icons too.