Merging text and formula results

S

stangard

I have a formula that I want to append text to. The results will then
display the number from the formula and units in one filed on my report.
 
J

JackD

Use a text field.

If your formula is something like this:

[duration]*[number5]

and you want it to show "days" after it then simply modify the formula to
be:

[duration]*[number5] & " days"

It is preferred that the formula be self contained - that is don't make it
dependent on formulas in other fields.

-Jack
 

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

Top