syntax error - missing operator - in query expression

Question

I am asked to do the following:

Create a new table, named sec0902_employees, that adds two new columns to the l_employees table.

Create the new columns by using the following row functions:

Column Name: full_name

Access: first_name & ' ' & last_name

Column Name: new_credit_limit

Access: credit_limit + 10.00

Here is my code:

select l_employees.*, 
first_name & ‘ ‘ & last_name as full_name,
credit_limit as new_credit_limit + 10.00
into sec0902_employees
from l_employees;

This is the error:

Syntax error (missing operator) in query expression ‘first_name & ‘ ‘ & last_name as full_name’

Here is a screen shot of the original l_employees table:

Thank you for any assistance you can provide :-)

Your are missing a comma. This is simply a typographical error. — Gordon Linoff
– Gordon Linoff, Commented Nov 22, 2018 at 15:18
is ‘ a valid quote in access ? Try using a normal quote, ' — Cid
– Cid, Commented Nov 22, 2018 at 15:20

forpas · Accepted Answer · 2018-11-22 15:25:40Z

2

Did you mean:

(credit_limit + 10.00) as new_credit_limit

the alias of the new column is new_credit_limit
and it consists of the value of credit_limit + 10.00 isn't it?

answered Nov 22, 2018 at 15:25

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3838910 · Accepted Answer · 2018-11-22 17:38:29Z

0

Thanks!! :-) This is the code that worked:

select l_employees.*, first_name & ' ' & last_name as full_name, (credit_limit + 10.00) as new_credit_limit into sec0902_employees from l_employees;

answered Nov 22, 2018 at 17:38

user3838910

234 bronze badges