CREATE VIEW Query

  • Thread starter Thread starter Sol
  • Start date Start date
S

Sol

I need help in figuring out how to do the CREATE VIEW function.
Here are some of the exercises I need to do:

Create a view named PenguinBooks. It consists of the book code, book title,
book type, and book price for every book published by Penguin USA. Display
the data in the view.

I followed every rule possible, but came up empty.
An error message pops up rejecting the operation.
Any suggestions?
Sol
 
Is this an Access question. Sounds like a SQL Server one.
Why not post the SQL statement, the error messages, and sample data?
 
With Jet, a VIEW is implemented as a select query with no parameter (while a
JET select query with one or more parameter is like a PROCEDURE of one
statement). So, to make a short story, make a SELECT query, save it, and
use it as required.



You can always use CREATE VIEW syntax with Jet, from ADODB, but not from DAO
.... Since the Access query designer is DAO based... and I assumed you use
the Access query designer... So simply use a select QUERY.



Vanderghast, Access MVP
 
Back
Top