Way to combine text,numberdate fields without type conversion erro

  • Thread starter Thread starter bird lover
  • Start date Start date
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.
 
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
 
Back
Top