Results 1 to 2 of 2
  1. #1
    Nick F is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    37

    Problem displaying information from a Union query

    Hello,

    The setup: Fish are entered into the database depending on the way information was collected (three different ways). I am trying to write a query that will return a list of species seen for a specific stream in a specific year. I wrote a query for each method to tease out species and then wrote a union query to get a list for the whole stream. The individual queries work great. The union query worked accept it does not give me the species name but the unique identifier it has in the lookup table that I use for data input.

    Stream Test
    Site One
    Method one: Johnny Darter, Common Shiner
    Method two: Brown Trout
    Mehtod three: None

    Site Two
    Method one: Golden Shiner, Common Shiner
    Method two: Brown Trout, Brook Trout
    Method Three: Brook Trout

    After the query is run, I should just get a list of the following species:
    Johnny Darter
    Common Shiner
    Brown Trout
    Golden Shiner
    Brook Trout

    Instead I get this:
    36
    46
    1
    6
    2
    When I look up these numbers in the species table, it matches nicely but I want to just see the species. The numbers have no meaning to me.

    Any help would be greatly appreciated.

    Cheers
    Nick

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,016
    Do a query joining the UNION query to the species table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-04-2012, 07:17 PM
  2. Union query problem
    By andreei87 in forum Queries
    Replies: 5
    Last Post: 05-09-2011, 09:39 AM
  3. Union ALL problem
    By witooldas in forum Queries
    Replies: 1
    Last Post: 04-29-2011, 07:12 AM
  4. problem displaying data in report
    By dreamweaver547 in forum Reports
    Replies: 4
    Last Post: 10-15-2010, 04:26 PM
  5. Lab information database problem
    By stupesek in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 04:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums