Good afternoon all. I have a simple MS query that uses the concat() statement to combine 2 strings. It works with 2 strings that are all alpha. When I try to concat a string that is of the format 14-2015, I get the error "Collate Sequence Mismatch" Is this a string problem? When I return the data In XL I can use the concatenate() command and it combines fine, but in the query it dosen't. Thanks for ant help.

Alan