Merge fields on a query table

[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.

 

[Dennis]

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