Limit w/ Label Wizard

[Clint Hill]

Beginner (absolute)
How do I include fields from more than one table on a
label? Using the Label Wizard, I am limited to only one
table's values.

Thanks for your prompt response....

 

[Fredg]

Make a query that combines all the tables/fields you need to use.
Make sure all the relationships between the tables are correct.
Use this query as the record source for the label wizard when the new report
dialog asks.

 

[Mike Mueller]

: Beginner (absolute)
: How do I include fields from more than one table on a
: label? Using the Label Wizard, I am limited to only one
: table's values.
:
: Thanks for your prompt response....

Forms and reports can only pull information form 1 source,
be it a table or a query. To use more than 1 source, tie
the information together in (an)other query and base the
report on that new query

HTH

Mike