Merge cells for display

  • Thread starter Thread starter Matthew
  • Start date Start date
M

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
 
Matthew said:
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.
Click to expand...

Add an additional field that uses an expression...

NewField: [Field 1] & Left([Field 2],1)
 
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,
 
Back
Top