I use Microsoft Query to connect and to bring in the information from a
database in a SQL server. I have no problem bring the info in. However, I
have a problem creating a custom field.

For example, I have Fields (Columns) A and B. I want to create Field C that
combines the values from Fields A and B. In Access, I can create a Field C
by writing this expression in a query:

Field C: Field A & Field B

I tried to write a similar expression, and it does not recognize it. Please
help.

Thanks.