A View is a Query, but a Query is not a View. In other words, a Query is a subset of a View - you can do much more with a View. For example, a View can contain one or more Common Table Expressions (CTE) to simplify or enhance the result of the final query. You can't use a CTE in an Access query - you have to build a query on other queries.
Posted by: John Viescas <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|