Combine Fields on a Report

[Guest]

I have a form/crosstab query/report structure set up as follows. The user
opens a form and enters in date parameters and a producer code based on a
look up from our producer table. The combobox displays four columns of
information to help the user make his/her selection. One of those columns is
producer name. A crosstab query summarizing their submission volume is
generated (using the date and producer code parameters) which feeds into a
report. On the report header I would like to show both the producer code and
the producer name. The name is contained in the producer table but isn't in
the crosstab query. The report is currently displaying just the producer
code using the following syntax - =Forms!ProducerSummarySubForm!Producer.
Everything is working just fine but I can't figure out how to concantonate
the Producer Name to the end of the producer code. Any thoughts? Thanks.

 

[AlCamp]

I have a form/crosstab query/report structure set up as follows. The user
opens a form and enters in date parameters and a producer code based on a
look up from our producer table. The combobox displays four columns of
information to help the user make his/her selection. One of those columns
is
producer name. A crosstab query summarizing their submission volume is
generated (using the date and producer code parameters) which feeds into a
report. On the report header I would like to show both the producer code
and
the producer name. The name is contained in the producer table but isn't
in
the crosstab query. The report is currently displaying just the producer
code using the following syntax - =Forms!ProducerSummarySubForm!Producer.
Everything is working just fine but I can't figure out how to concantonate
the Producer Name to the end of the producer code. Any thoughts? Thanks.

 

[AlCamp]

Rob,
Hope I understand correctly...
Say the ProducerName is in the 3rd column of your form's ProducerCode
combobox.
Then this concatenation should work...

=Forms!ProducerSummarySubForm!Producer & "-" &
Forms!ProducerSummarySubForm!Producer.Column(2)

(Combobox columns are numbered 0,1,2,3 etc..)
hth
Al Camp

 

[Guest]

Al,

That worked perfectly! Thanks for the assist!

 

[Guest]

Al,

That worked perfectly. Thank you so much for the assistance!