Create View

  • Thread starter Thread starter Alberto
  • Start date Start date
Alberto,

Yes you can.
"CREATE VIEW Albertos_View AS SELECT * FROM Albertos_Table"
will work.
You can even have parameters

"CREATE PROCEDURE Albertos_proc AS SELECT * FROM Albertos_Table WHERE
SomeKey=uVal1 AND SomeOtherField=uVal2"
Will work also.

hth,

Erik Visser
 
If you go to the query tab, and create a new query, and that query is a
select query...then that is the same thing as a view. Once that query is
made, you can build other queries on that query, or use that query anywhere
in ms-access in place of a table.

However, the query page also allows you to create update query, delete query
append quires..and for that reason we don't always refer to queries built in
the query page as views...but when they are select queries, then for all
purposes...they are views.
 
Back
Top