Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Losing lookup information in a union query

    I have a table that has a number of lookup fields. These all have the same three-column row source but I only display the values from the middle one by setting the other two column widths to zero. The first column is the foreign key and the third is a column that I filter by. I have a union query that includes all of these lookup fields in the same column. The problem is that in the results of the union query I lose the looked-up values and just get the foreign key returned. Any ideas? (Or any better ways to get the same information?) All answers extremely gratefully received!

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    no idea what you mean from your description (column width zero?)

    try UNION ALL instead of UNION

    otherwise please show your query


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts