Appending text to a number field

[paperbag1]

How can you make a field append a text phrase to a number you just entered in the same field. eg... If I were to enter a 6 in the field, what you would see in the field is: 6 hrs. @ $25.00 per hr.

I've tried making the field a calculation but it won't let me modify anything in the field.

Thanks,

Phil

[LaRetta]

Hi Phil,

Assuming the Rate exists within the same table, set hoursField to be Auto-Enter by calculation (UNclick Do Not Replace Existing Value). Be sure your hours field is TEXT and calc would be something like:

hoursField & " hrs. @ " & Rate & " per hr."

However, I don't suggest you do this, Phil. It is usually easier to use merge fields to display these types of strings ... or even leave your hours field number and create a new indexed calc to hold this string (or even an Auto-Enter as described above).

It really isn't a good idea to combine your hours (number) with text. Why? Because sure as the sun rises, you'll want to total those hours (or treat them as real numbers) and you'll have to break it up again anyway.

As comment once said, why put it together just to break it up again.

LaRetta

[paperbag1]

Thanks LaRetta. I see what you mean about combining. I'll go at it another way.

Phil