Commas

  • Thread starter Thread starter Ellen
  • Start date Start date
E

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
 
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
Click to expand...

So what is the problem?
 
-----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
Click to expand...

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

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.
 
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
Click to expand...

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

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.
Click to expand...
 
-----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
Click to expand...

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

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.
Click to expand...

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.
 
Back
Top