Microsoft Access Data Base .. Select Query

Question

i am doing queries practice in Microsoft access. i want to concatenate the first name with the fax number.. the fax number is like (123)555-0103 .. i`m doing that

select [first name] +' ''s Fax Number is' +str(fax number) as [Mariya`s Fax Number] 
from employees where id =4;

but it is giving error..

Answer 1

That would be:

select [first name] & " ''s Fax Number is " & [fax number] as [Mariya`s Fax Number] 
from employees where id =4

You should use & to concatenate
You should use '' for each single quote
You should use double quotes (") for strings.