Prev: Query Result Incorrect
Next: State abbreviation MI fails in query
From: bwjohnson1 on 14 Jan 2010 09:57
For example, a contract ID looks like "9999P01" or "604527P05".

To do a Journal entry in our accounting software, I need to add a "Z" to the
end of each contract ID.

How can I convert the ID's above into 9999P01Z and 604527P05Z?
From: Dorian on 14 Jan 2010 10:12
Where is your data, in a table or in a control or in a variable or what?
Normally, you would do something like:
Mycolumn = Mycolumn & "Z"
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"bwjohnson1" wrote:

> For example, a contract ID looks like "9999P01" or "604527P05".
>
> To do a Journal entry in our accounting software, I need to add a "Z" to the
> end of each contract ID.
>
> How can I convert the ID's above into 9999P01Z and 604527P05Z?
From: bwjohnson1 on 14 Jan 2010 12:17
Thanks,

That worked great. I thought I tried that already but I must have done
something wrong. Oh well, Thanks again.

"Dorian" wrote:

> Where is your data, in a table or in a control or in a variable or what?
> Normally, you would do something like:
> Mycolumn = Mycolumn & "Z"
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "bwjohnson1" wrote:
>
> > For example, a contract ID looks like "9999P01" or "604527P05".
> >
> > To do a Journal entry in our accounting software, I need to add a "Z" to the
> > end of each contract ID.
> >
> > How can I convert the ID's above into 9999P01Z and 604527P05Z?
 | 
Pages: 1
Prev: Query Result Incorrect
Next: State abbreviation MI fails in query