SQL ACCESS error 1

[geon12x]

here is a very simple query I made

CREATE VIEW ML_CUST AS
SELECT CUSTOMER.FirstName,
CUSTOMER.LastName,
CUSTOMER.Phone
FROM CUSTOMER
WHERE CUSTOMER.State ='ML' ;


and I can't even do it right.

error in view when I run it...

 

[PHV]

JetSQL don't deal with views.
A workaround is to create a select query named ML_CUST and then use it like a view.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sblocher]

You can create "views" in Access. They end up as "Queries", but same thing, just different name.

Try this:

CREATE VIEW ML_CUST (FirstName, LastName, Phone)
AS SELECT CUSTOMER.FirstName,
CUSTOMER.LastName,
CUSTOMER.Phone
FROM CUSTOMER
WHERE CUSTOMER.State ="ML" ;