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

Similar Threads

Using table field in Lookup Wizard 3
Two Tables with the same field name 2
Field concatenation into a combo box 5
Access Dcount (multiple criteria) 3
Calculations, Queries and making it all come together in my table 4
calculated field on a form 10
Merge multiple records in a field, based on criteria? 2
Create a query to merge records with two fields as criteria 1

Back
Top