Concatanate two fields

[HelsBels]

Hello

Is there a formula that I can use that will put two fields together. At the moment I have two fields that are separate but need to be put together in an extract file.

i.e The first field has 4 characters and the 2nd field has 3 characters, I need a formula that will join the two together to make one field with 7 characters?

 

[dcx693]

If both fields are text fields, create a calculated field in a query where both fields are in the source table(s). Use an expression like this in the "Field" line of the QBE grid in design view to join the two fields, assuming they're called Field1 and Field2: [Field1]&[Field2]. Access will automatically give a name to this new column in the form "Expr1". You can name this column something more logical by changing the part before the ":" symbol. Send the output from this query to your extract file.