Re: append contents of field to another field
- From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 23 Apr 2005 16:43:02 -0400
"RipperT @comcast.net>" <rippertsmith<nospam> wrote in message
news:uj$uikDSFHA.2788@xxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I would like to (using code) have text data from a table field be
> automatically appended to the end of text data entered in another
> field. Specifically,
>
> Field 1: "123456"
> Field 2: "ww.somewebaddress.net/subfolder/" (default value)
>
> I need the result of field 2 to look like this:
> "ww.somewebaddress.net/subfolder/123456"
>
> without having to type the contents of field 1 twice. How would I do
> this?
>
> Many thanx,
>
> Rip
It's easy enough to do, but why do it? Are you planning to remove Field
1 from your table? If both Field 1 and Field 2 are going to exist in
your table, then why not just use a calculated field in query to
concatenate them whenever necessary? Like this:
SELECT [Field2] & [Field 1] AS WebPage FROM MyTable;
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
- Follow-Ups:
- Re: append contents of field to another field
- From: RipperT
- Re: append contents of field to another field
- References:
- append contents of field to another field
- From: RipperT
- append contents of field to another field
- Prev by Date: Re: Set Focus & 2108 error
- Next by Date: Re: Mail Merge Module fails to open Data Source
- Previous by thread: append contents of field to another field
- Next by thread: Re: append contents of field to another field
- Index(es):
Relevant Pages
|
|
