Combine text and numbers into a field on a report

  • Thread starter Thread starter Ed-Masto
  • Start date Start date
E

Ed-Masto

Hello All:

In MS Excel, I use concatenate function to combine fields that are text and
nubers. How do I do that in access? For example, I have a field called Unit
Price and I need to combine that with "per unit" text as well as some other
text fields from the recordset.

Any Help would be great!

Kindest regards
 
You would generally use the ampersand "&" to join strings:
In a control source (the name of the control can't be a field name)
=[Unit Price] & " per unit"
New column in a query design
PricePerUnit: [Unit Price] & " per unit"
 

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

combining text in a report field? 1
Combining two date fields in a report 4
generating a report based on fields 1
Concatenate 3 fields on the reports 3
Combining 2 text field into one 10
Format Combined Fields 3
Group last line of details and report footer 0
Combine field data 1

Back
Top