How to Combine Fields

[AussieRob]

Can some one help me with a quick question. Can I combine two fields in a query to create one joint field?

Field 1: Unit Name
Field 2: Unit No

In this case Unit Name is something like Hatfield, and Unit number is 2. I would like the query to show Hatfield 2.

Thanks for your help.

 

[Norie]

Try this expression.

NewField:[Unit Name] & [Unit No]

 

[AussieRob]

thank you, thank you, thank you