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

    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
    Location
    Toronto, Canada
    Posts
    20,002
    no idea what you mean from your description (column width zero?)

    try UNION ALL instead of UNION

    otherwise please show your query


    rudy

Posting Permissions

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