Problem Updating Memo fields w/SQL

I am having a problem using an sql query to update memo fields in access. Is there some sort of bracketing ro something I need to use?

Here is my code,

sql= "update jobs set province='"& province &"', [date]='"& idate &"', school='"& schoolname &"', jobtitle='"& jobtitle &"', salary='"& salary &"', contactname='"& contact &"', tel='"& iphone &"', email='"& iemail &"', website='"& website &"', info='"& iinfo &"', [memo]='"& description &"' where id like 3"

The last 2 are memo fields


Thanks everyone!

Are you sure it is you memo field and not your date fields and numerix fields that are giving you the trouble (they are wrong too).


sql= "update jobs set province='"& province &"', [date]= #"& idate &"#, school='"& schoolname &"', jobtitle='"& jobtitle &"', salary="& salary &", contactname='"& contact &"', tel='"& iphone &"', email='"& iemail &"', website='"& website &"', info='"& iinfo &"', [memo]='"& description &"' where id like 3"

S-

the date fields work fine. The memo fields dump the contents of the field right into the sql statement:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I was recently given the position that was posted on your site. However, I have had a change of circumstances that has meant I cannot continue teaching here. I don't want to leave them in trouble so please could you repost the same advert you had posted '.


thanks

When using SQL statement the way you are trying you can't have a ' in the data.

Try removing the ' and see what happens


S-