Commas

[Ellen]

Hello,
I'd like to have a line on my report with the city, a
comma, then the state. I know I need this information in
a text box. I assume it'll look like this:
=[city]&", "&[state]

I'd also like to have another report for which I can get e-
mail addresses. I assume I'll have a similar text box
with the code:
=[e-mail]&";"

Can some one help me?

Ellen

 

[fredg]

Hello,
I'd like to have a line on my report with the city, a
comma, then the state. I know I need this information in
a text box. I assume it'll look like this:
=[city]&", "&[state]

I'd also like to have another report for which I can get e-
mail addresses. I assume I'll have a similar text box
with the code:
=[e-mail]&";"

Can some one help me?

Ellen

So what is the problem?

 

[Guest]

-----Original Message-----

Hello,
I'd like to have a line on my report with the city, a
comma, then the state. I know I need this information in
a text box. I assume it'll look like this:
=[city]&", "&[state]

I'd also like to have another report for which I can get e-
mail addresses. I assume I'll have a similar text box
with the code:
=[e-mail]&";"

Can some one help me?

Ellen

So what is the problem?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Hello, Fred. Yes. It works. For some reason when I tried
it on my girlfriend's computer using Access 97 I kept
getting an error message.

 

[Duane Hookom]

That's the problem with girl friends ;-)

--
Duane Hookom
MS Access MVP

-----Original Message-----

Hello,
I'd like to have a line on my report with the city, a
comma, then the state. I know I need this information in
a text box. I assume it'll look like this:
=[city]&", "&[state]

I'd also like to have another report for which I can get e-
mail addresses. I assume I'll have a similar text box
with the code:
=[e-mail]&";"

Can some one help me?

Ellen

So what is the problem?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Hello, Fred. Yes. It works. For some reason when I tried
it on my girlfriend's computer using Access 97 I kept
getting an error message.

 

[fredg]

-----Original Message-----

Hello,
I'd like to have a line on my report with the city, a
comma, then the state. I know I need this information in
a text box. I assume it'll look like this:
=[city]&", "&[state]

I'd also like to have another report for which I can get e-
mail addresses. I assume I'll have a similar text box
with the code:
=[e-mail]&";"

Can some one help me?

Ellen

So what is the problem?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Hello, Fred. Yes. It works. For some reason when I tried
it on my girlfriend's computer using Access 97 I kept
getting an error message.

In all probability, the name of the control on her machine was the
same as the name of one of the fields used in the expression. That
will generate an #Error.