Merge fields on a query table

  • Thread starter Thread starter Leo Rod
  • Start date Start date
L

Leo Rod

Please if anybody knows how let me know how to put together two fields from
the same table on a calculated field; I want something like the concatenate
function in Excel that can put together name and last name from a table into
the same output field separated by a " ".

Any other references on how to operate with text and data in queries and
calculated fields will be very much appreciated.

Greetings,

Leo.
 
In your query just put this in the Field Row of a column in your query design
grid

FullName: [Name] & " " & [LastName]

Calculations are similar

IncVat: [Price] * 1.175
 
Back
Top