Combine text and numbers into a field on a report

[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

 

[Duane Hookom]

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"