Merge cells for display

[Matthew]

I would like to make a query to take the full contents of one field and the
first character of another field and put them together in the same field in
the query.

Field 1 = 1456
Field 2 = Maple
Query result = 1456M

Note: I do not want to modify the original data.

Can this be done?

Matthew

 

[Rick Brandt]

I would like to make a query to take the full contents of one field and the
first character of another field and put them together in the same field in
the query.

Field 1 = 1456
Field 2 = Maple
Query result = 1456M

Note: I do not want to modify the original data.

Add an additional field that uses an expression...

NewField: [Field 1] & Left([Field 2],1)

 

[Cheryl Fischer]

Sure. It's called concatenation.

In the first row of an empty column in the query's design view, type the
following:

MyNewField: Field1 & Left(Field2, 1)

hth,

 

[Matthew]

Thanks for your help.

It worked beautifully!

Matthew