Binding Union query to report - field problem

[am2645]

I created a report that was derived from a previously set union query. The report queried correctly, but showed certain fields as their recordID instead of their actual description.

Is there any way to modify this?

 

[dhookom]

Include the "actual description" field (maybe the table also) in the union query.

If you are using lookup fields defined in your tables, consider changing them to standard fields with no lookup.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]