concatenate in "update to" field

[scubadiver007]

I have a table linked from DB1 in DB2 and I need to concatenate two fields in the table and update a field in another table in DB2.

I have this in the "update to" field but it isn't working.

"2011/12 COMPLETION DATE: " & [11-12 appraisals].[appraisal_completedate] & " - Comments" & [11-12 appraisals].[comments_currentyr]

 

[sparks80]

Hi,

I can't see anything that is obviously wrong with the syntax for the code you have given. Is there any chance you could post the full SQL code, this is not much information to go on!

One or two thoughts:

Is it possible that there are null values that are causing a problem? If so you could use the NZ function to return a zero-length string instead.

Is it possible that the resulting text string is of the wrong data type, or too long to be inserted into the 3rd table?

Lastly it is worth naming your tables and fields without spaces, use the underscore symbol instead. This will save all sorts of headaches when writing SQL or VBA code!