How to print part of a composed field on a report?

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

Guest

Hello all,

How do I print only the second part of a composed field on a report? The
field itself is composed from three other fields from another table, e.g.
SELECT tabl1.f1, table1.f2, table1.f3 FROM etc... etc...

Now what I would like to do is to use the second component of the above
field and print it on my report. Your help is greatly appreciated.
 
Then simply add a new control with the source of table1.f2 to your report.

Am I missing something?
 
Hi Rick,

Thanks for your reply. I think a bit more explanation is needed.

The composed field provides users with a dropdown list of "products", their
codes and related reference numbers. They are SELECTed from another table,
namely the "products" table. There is no explicit relationship to my current
table.

Users are presented these entries as a dropdown list on a form. Once the
user selects an element from the list, the result is stored on my current
table. The composed field is defined as TEXTI am not sure which

If I was to adopt your solution, I would have to introduce an extra field on
the entry form, but this time a dropdown list of entries containing only the
second element. I guess, I could eventually program the procedure to populate
the new field, but I was looking for a way to avoid the more laborious
solution.

Once again, all help is greatly appreciated.
 
Back
Top