is this possible?

  • Thread starter Thread starter Jim Allen
  • Start date Start date
J

Jim Allen

I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3

Any help would be appreciated.
Thanks.
Jim
 
Jim said:
I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3
Click to expand...


Set the text box's control source expression to:

=("Memo 1: " + [memo1]) & ("Memo 2: " + [memo2]) & . . .

this works because + propogates nulls, but & does not.
 
Thanks Marsh. I was using '&' and couldn't figure out
what was the problem.
-----Original Message-----
Jim said:
I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3
Click to expand...


Set the text box's control source expression to:

=("Memo 1: " + [memo1]) & ("Memo 2: " + [memo2]) & . . .

this works because + propogates nulls, but & does not.
Click to expand...
 
Back
Top