Way to combine text,numberdate fields without type conversion erro

[bird lover]

I use access 2003 and am not familiar with Sql, basic or similar technical
language.

I need to create an update query for [combofield] to accomplish the following:

[datefield]+"-"+[textfield]+"-"+[numberfield] but get a type conversion
error.
The datefield should come out yymmdd.
Sample should look like: 081106-nassau-11501

Any help in providing appropriate syntax would be greatly appreciated.

 

[Allen Browne]

Use Ampersand rather than Plus as the concatenation operator.

And use Format() to force the format you want for your date:

Format([datefield], "yymmdd") & "-" & [textfield] & "-" & [numberfield]

If you do insert dashes, you may find that Access handles the data
inconsistently:
http://support.microsoft.com/kb/271661