Access 2016 SQL

[Arif_Tamboli]

Hi
while creting VIEW in SQL getting an error "Syntax error in CREATE TABLE statement"

Below are my Query
CREATE VIEW NH_CUST AS
SELECT CUSTOMER.FirstName ,
CUSTOMER.LasName ,
CUSTOMER.Phone ,
FROM CUSTOMER
WHERE CUSTOMER.State = 'NH' ;

 

[Joe4]

Where exactly are you trying to use this code in Access?
Is it in VBA?

If it is just in SQL View of a Query, just use:

[COLOR=#333333]SELECT CUSTOMER.FirstName [/COLOR]
[COLOR=#333333]CUSTOMER.LasName,[/COLOR]
[COLOR=#333333]CUSTOMER.Phone,[/COLOR]
[COLOR=#333333]FROM CUSTOMER[/COLOR]
[COLOR=#333333]WHERE CUSTOMER.State = 'NH';[/COLOR]

and save the query with name "NU_CUST".

 

[xenou]

That looks like non-MSAccess SQL (every database has it's own flavor of SQL). As above, views in Access are just saved queries plain and simple.

 

[igold]

@xenou,

I had to ponder it a little, but the Thoreau quote in your signature, is spot on.

Thanks!