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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top