Need some know how here please. I have created a query from a single table and have several columns which amongst others includes one for "surname" and one for "initials". When I run the query the surnames and initials show up, no problem there.
When I however try to concatenate the two fields in a new query column using the following syntax
Expr1: [surname] & [initials]
and then run the query the result for this concatenated column is a list of two digit numeric values instead of the combined surname and initials. Nowhere else in the table is there fields that contain these two digit numeric values so where they are coming from is a mystery to me.
What am I doing wrong?
When I however try to concatenate the two fields in a new query column using the following syntax
Expr1: [surname] & [initials]
and then run the query the result for this concatenated column is a list of two digit numeric values instead of the combined surname and initials. Nowhere else in the table is there fields that contain these two digit numeric values so where they are coming from is a mystery to me.
What am I doing wrong?