REPLACE cVar1 WITH TRANSFORM(IIF(nVar1 < 13, nVar1, nVar1-12)) + ":" + ;
PADL(nVar2, 2, "0") + IIF(nVar1 < 12, " am", " pm")
>Hi All:
>
>I have a situations where the table consists of 2 numeric fields. Programatically, I have two numeric variables calculate the numbers that are to be inserted into the 2 numeric fields in the table. This has been accomplished.
>
>I have another character field in the same table, where I want to concatenate the values stored in the two numeric variables described above, to be stored in this character field.
>
>Example: nVar1 = 8, nVar2 = 00
>Desired Outcome is the value "8:00 am" which is to be stored in the character field.
>
>Your guidance is appreciated. Thanks.
>
>- Ravi
--sb--