You are here:

Using MS Access/Expression combining number & text

Advertisement


Question
Report image
Report image  
I would like to show the height and width of an item (stored separately in number fields)in a report like this "h x w".  For example, height 10, with 15, report would show 10 x 15.  I tried doing =[Height] & " x " & [Width] and the report showed the same information for each item (360 x 13260).  If I include the fields separately it shows the appropriate numbers for Height and Width. I am attempting to enter the expression via the Control Source expression builder in the properties box of a text box field in a report.

I hope this is enough information!

Answer
Try making this a calculated query field. In a QUERY, say:

Area: Height & "x" & Width

Now use that query for your report and it will show up in the Field List.

Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
599CD Computer Training  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.