Concatenation Problem/"Enter Parameter Value" pop up

[Herakleitos]

I'm trying to concatenate (I thinks that's the word) fields in Access 97. Using an update query where the field to be updated is a memo field. I have the following in the "Update To" section of the query design:

[ImportTable1]![Desc] & " " & [ImportTable1]![Low] & " " & [ImportTable1]![High] & " " & [ImportTable1]![CompTypeID] & " " & [ImportTable1]![EmployTypeID] & " " & [ImportTable1]![Reloc] & " " & [ImportTable1]![Sponsor] & " " & [ImportTable1]![YearsID]


But, when I try to run it, I get a "Enter Parameter Value" pop up for every table except the first one (Desc). Desc is a memo field and all the others are text fields. Some of the text fields have null values (but not all)

And, if I enter anything in the pop up (though I have no idea what to enter, I tried "Is Not Null&quot, the query runs - joining the memo info from the Desc field to whatever I enter in the pop up (i.e. not the values that are actually in those fields.

Anyone have a clue?

 

[igk]

Try to put Nz function for each item:
[ImportTable1]![Desc] & " " & Nz([ImportTable1]![Low],"&quot & " " & Nz([ImportTable1]![High],"&quot & " " & Nz([ImportTable1]![CompTypeID],"&quot & " " & Nz([ImportTable1]![EmployTypeID],"&quot & " " & Nz([ImportTable1]![Reloc],"&quot & " " & Nz([ImportTable1]![Sponsor],"&quot & " " & Nz([ImportTable1]![YearsID],"&quot