Concatentation woes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field:
tblPKCGPhysicalAttributes.Style

Style is a combo box that queries:
tblPKCGStyles.txtCodeID.CorrugatedStyles

txtCodeID is the bound column and it's values are saved in the Style field.

My report needs to display both txtCodeID and CorrugatedStyles.

I'm very confused by this and would greatly appreciate any guidance you
might have.

Thanks!
 
Can you add the table tblPKCGStyles to your report's record source and
include the field?
 
Thanks, Duane. tblPKCGStyles is an unrelated table. If I add to the query
then I'll have issues.

Do I need to make this table relational in order to have both txtCodeID and
CorrugatedStyles display on my report?
 
JohnLute said:
I have a field:
tblPKCGPhysicalAttributes.Style

Style is a combo box that queries:
tblPKCGStyles.txtCodeID.CorrugatedStyles

txtCodeID is the bound column and it's values are saved in the Style field.

My report needs to display both txtCodeID and CorrugatedStyles.

I'm very confused by this and would greatly appreciate any guidance you
might have.
Click to expand...

Add the tblPKCGStyles table to the report's record sosurce
query. Set the join line between the two tables from
tblPKCGPhysicalAttributes.Style to tblPKCGStyles.CodeID.
Then you can add the CorrugatedStyles field to the query's
field list.
 
Back
Top