Hello, i have written and insert statement to insert data into a table. The very last field in the table and in the insert statement is a memo type field. When i run this statement i get a Syntax Error. If i remove the memo field data from the statement it runs just fine and inserts all of the data. What i am missing here? I don't see it. Should i be formatting it differently for the memo field?
INSERT INTO ShipTo (ProjectID,Company,Attention,Address1,City,StateID,Zip,Phone,Email,Note) VALUES (4,'My Company','Johnny Rocket','2000 My Street','Fort Worth',43,'76001','817-626-0987','firstname.lastname@example.org','This is a memo test.')