J
JohnLute
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been unsuccesful.
Here's JulieD's post followed by my challenge:
Hi Dave
you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in, followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName
in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName
Hope this helps
Cheers
JulieD
What I'm doing is concatenating txtCodeID and CorrugatedStyles. The query I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]
When I leave design mode the "Enter parameter" dialogue boxes appear for
txtCodeID and CorrugatedStyles.
What am I doing wrong?
concatenating. I've tried to apply it to my report but have been unsuccesful.
Here's JulieD's post followed by my challenge:
Hi Dave
you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in, followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName
in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName
Hope this helps
Cheers
JulieD
What I'm doing is concatenating txtCodeID and CorrugatedStyles. The query I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]
When I leave design mode the "Enter parameter" dialogue boxes appear for
txtCodeID and CorrugatedStyles.
What am I doing wrong?