CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Cancatinateing fields

Print topic Send  topic

Author Message
Roger Rabbit
Posted: 02/18/2001, 12:27 PM

What I want is to make a single field named "FullName" that contains
Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
would I do that?

Thanks in advance for any help.

Dante S.
Posted: 02/18/2001, 7:06 PM

You can do this via customized SQL SELECT, eg.

SELECT Trim(LastName) & ", " & Trim(FirstName) FullName, address,...etc....

Don't know the exact syntax, but I hope you get the idea.

Regards,
Dante S.

"Roger Rabbit" <rrabbit@bunnyville.com> wrote in message
news:96pb87$4ji$1@news.codecharge.com...
> What I want is to make a single field named "FullName" that contains
> Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> would I do that?
>
> Thanks in advance for any help.
>
>

Alexey Alexapolsky
Posted: 02/19/2001, 12:55 AM

Also you can add your own field to a form.
Let's suppose it's name(not caption) is myfield.
Now click Form Properties icon , select "Events" tab ,
select "Show" event. Here you can enter your code that will
run when the form is shown. You can change values of fields right
here , but they must be prefixed with fld . In your case
you must enter code smth like :
fldmyfield = fldfirst_name & " " & fldsecondname ,
or if your lang is different use your own concatenation operator.

--
Regards,
Alexey
CodeCharge Support

Roger Rabbit <rrabbit@bunnyville.com> wrote in message > What I want is to
make a single field named "FullName" that contains
> Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> would I do that?
>
> Thanks in advance for any help.
>
>

Roger Rabbit
Posted: 02/20/2001, 3:02 AM

Thanks for the help. I'll try that.

Roger Rabbit
Posted: 02/20/2001, 10:36 AM

Alexey;

This works great on update but if I enter a new client I have to update the
record before the FullName field gets filled. I've placed the code in
"Show", "Show on Insert", and "Show on Edit" but it doesn't seem to matter.
The event is not acted upon until I go to the form and click "Update".

Any suggestions would be appreciated.

RR
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:96qn1m$h9n$1@news.codecharge.com...
> Also you can add your own field to a form.
> Let's suppose it's name(not caption) is myfield.
> Now click Form Properties icon , select "Events" tab ,
> select "Show" event. Here you can enter your code that will
> run when the form is shown. You can change values of fields right
> here , but they must be prefixed with fld . In your case
> you must enter code smth like :
> fldmyfield = fldfirst_name & " " & fldsecondname ,
> or if your lang is different use your own concatenation operator.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
> Roger Rabbit <rrabbit@bunnyville.com> wrote in message > What I want is to
> make a single field named "FullName" that contains
> > Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> > would I do that?
> >
> > Thanks in advance for any help.
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.