Concatenate a formula with a field

[Dandas]

Here is one that is probably simple to most of you. I need to concatenate a formula which is a half hour period ending i.e. 10:00 or 08:30 with a field which is a number i.e. 101 or 999.

I have been trying using the following formula.

{@RoundedPeriod}+{VW_CFG_TRANSACTION_CODE.TRANSACTION_CODE}

Ecah time I use this and anything similar I get an error message that says "A string is required here" and the cursor moves to where the "X" is

{@RoundedPeriod)+ "X"{VW_CFG_TRANSACTION_CODE.TRANSACTION_CODE}

Any suggestions on how to overcome this?

 

[dgillz]

Assumming both your fields are not text, you need to convert them to text first as follows:

Totext({@RoundedPeriod))+"X"+totext({VW_CFG_TRANSACTION_CODE.TRANSACTION_CODE}) Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Dandas]

Thanks so much.

That worked perfectly. I have a new problem now but I will post it on a different thread so it has the right topic.

Thanks heaps, you totally Rock !!!