|
 |
access thread: Trim function Question
Message #1 by "Div Fernando" <devinda.r.fernando@d...> on Wed, 22 Jan 2003 15:28:50
|
|
I'm creating a custom letter - the wording is Generic, but the Names and
Addresses are custom coming from a source Query. I tried entering the
following function in the Control Source Field of the Properties Tab of
the Tex Box and it does not work? Can Anyone Shed any light on this
problem?
=Trim([Name])&","
Funnily enough, the Comma "," appears after the [Name], but the [Name]
only displays the Report's name and not the individuals from the Source
Query.
Message #2 by "Gerald, Rand" <RGerald@u...> on Wed, 22 Jan 2003 09:50:24 -0600
|
|
Hi Div,
[Name] is a reserved special value in reports and returns the name of
the
report.
It may be necessary to change the name of your "Name" field in order to
avoid this conflict.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 09:29
To: Access
Subject: [access] Trim function Question
I'm creating a custom letter - the wording is Generic, but the Names
and
Addresses are custom coming from a source Query. I tried entering the
following function in the Control Source Field of the Properties Tab of
the Tex Box and it does not work? Can Anyone Shed any light on this
problem?
=3DTrim([Name])&","
Funnily enough, the Comma "," appears after the [Name], but the [Name]
only displays the Report's name and not the individuals from the Source
Query.
Message #3 by joe.dunn@c... on Wed, 22 Jan 2003 15:58:02 +0000
|
|
The golden rule is never to call fields by names that can be confused with
reserved words in your application (commands, properties, default values,
etc.). If you no not there is always the POSSIBILITY that the application
becomes confused.
You have called your field 'Name' but you have not made clear that you mean
a field name in a table or query. The application assumes you mean the name
of the report.
Just make your expression include the table name as well as the field name
...e.g. =Trim([YourTable]![Name])&","
"Div Fernando"
<devinda.r.ferna To: "Access" <access@p...>
ndo@d...> cc:
Subject: [access] Trim function Question
22/01/2003 15:28
Please respond
to "Access"
I'm creating a custom letter - the wording is Generic, but the Names and
Addresses are custom coming from a source Query. I tried entering the
following function in the Control Source Field of the Properties Tab of
the Tex Box and it does not work? Can Anyone Shed any light on this
problem?
=Trim([Name])&","
Funnily enough, the Comma "," appears after the [Name], but the [Name]
only displays the Report's name and not the individuals from the Source
Query.
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
Message #4 by "Devinda R Fernando" <devinda.r.fernando@d...> on Wed, 22 Jan 2003 10:58:05 -0500
|
|
Gerald you're a Genius!
Thanks, it was making me tear my hair out here!
-Div
"Gerald, Rand"
<RGerald@u... To: "Access" <acce
ss@p...>
g> cc:
Subject: [access] RE: T
rim function Question
01/22/2003 10:50
AM
Please respond to
"Access"
Hi Div,
[Name] is a reserved special value in reports and returns the name of t
he
report.
It may be necessary to change the name of your "Name" field in order to
avoid this conflict.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 09:29
To: Access
Subject: [access] Trim function Question
I'm creating a custom letter - the wording is Generic, but the Names an
d
Addresses are custom coming from a source Query. I tried entering the
following function in the Control Source Field of the Properties Tab of
the Tex Box and it does not work? Can Anyone Shed any light on this
problem?
=3DTrim([Name])&","
Funnily enough, the Comma "," appears after the [Name], but the [Name]
only displays the Report's name and not the individuals from the Source
Query.
.
--
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in err
or) please notify the sender immediately and destroy this e-mail. Any u
nauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Message #5 by "Tech_Mark" <tek_mark@h...> on Wed, 22 Jan 2003 11:05:33 -0500
|
|
Div, will MS Word's mail merge capability do what you need?
Word will read Access tables. (And you can even create a custom query and
use that.)
Mark
----- Original Message -----
From: "Div Fernando" <devinda.r.fernando@d...>
To: "Access" <access@p...>
Sent: Wednesday, January 22, 2003 3:28 PM
Subject: [access] Trim function Question
> I'm creating a custom letter - the wording is Generic, but the Names and
> Addresses are custom coming from a source Query. I tried entering the
> following function in the Control Source Field of the Properties Tab of
> the Tex Box and it does not work? Can Anyone Shed any light on this
> problem?
>
> =Trim([Name])&","
>
> Funnily enough, the Comma "," appears after the [Name], but the [Name]
> only displays the Report's name and not the individuals from the Source
> Query.
>
Message #6 by "Gerald, Rand" <RGerald@u...> on Wed, 22 Jan 2003 10:06:33 -0600
|
|
Hi Div,
I use the [Name] value on all my reports to tag them with the report
name.
It makes it easier when trying to recreate an old report if you know
which
one it was. Unfortunately, this is not a well documented feature. I
wish
they had called it [ReportName]. [Name] is too generic.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 09:58
To: Access
Subject: [access] RE: Trim function Question
Gerald you're a Genius!
Thanks, it was making me tear my hair out here!
-Div
"Gerald, Rand"
<RGerald@u... To: "Access"
<access@p...>
g> cc:
Subject: [access] RE:
Trim
function Question
01/22/2003 10:50
AM
Please respond to
"Access"
Hi Div,
[Name] is a reserved special value in reports and returns the name of
the
report.
It may be necessary to change the name of your "Name" field in order to
avoid this conflict.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 09:29
To: Access
Subject: [access] Trim function Question
I'm creating a custom letter - the wording is Generic, but the Names
and
Addresses are custom coming from a source Query. I tried entering the
following function in the Control Source Field of the Properties Tab of
the Tex Box and it does not work? Can Anyone Shed any light on this
problem?
=3DTrim([Name])&","
Funnily enough, the Comma "," appears after the [Name], but the [Name]
only displays the Report's name and not the individuals from the Source
Query.
--
This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in
this
e-mail is strictly forbidden.
|
|
|
View Cart
