Way to combine text,numberdate fields without type conversion erro

B

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.
 
A

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
 
Top