Report Footer

[AL1999 via AccessMonster.com]

Hi,

I am trying to include this structure in the footer section of a report: But
I can't get each name of the person to come out. For eg, I have it as:


="Summary for " & "'Customers Name' = " & " " & [Name]

I hope you understand what i am trying to write here.


Regards,

Al

 

[Al Camp]

Al,
I take it that your report returns just one name... and that Name is a
text...
= "Summary for Customer Name = " & [Name]
should do it.

"Summary for" and "Customer Name = " and " " are all string values, so
they can all be treated within one set of quotes. No need to break them up.

 

[AL1999 via AccessMonster.com]

Thanks for your help.

Regards,

Al

Al,
I take it that your report returns just one name... and that Name is a
text...
= "Summary for Customer Name = " & [Name]
should do it.

"Summary for" and "Customer Name = " and " " are all string values, so
they can all be treated within one set of quotes. No need to break them up.

Hi,

[quoted text clipped - 9 lines]

Al

 

[Al Camp]

I appreciate the thank you, but more importantly... did my solution work?
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thanks for your help.

Regards,

Al

Al,
I take it that your report returns just one name... and that Name is a
text...
= "Summary for Customer Name = " & [Name]
should do it.

"Summary for" and "Customer Name = " and " " are all string values, so
they can all be treated within one set of quotes. No need to break them
up.

Hi,

[quoted text clipped - 9 lines]

Al