Results 1 to 3 of 3
  1. #1
    eizquierdo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    7

    Not even sure what to call this one

    I have a table with the following data:

    Decal User 1 User 2
    1 John
    2 Alex
    3 Jane Eric
    4 Pope Pete
    5 Robert


    And I wanted to create a query that displays:

    Decal User
    1 John
    2 Alex
    3 Jane
    4 Pope
    5 Robert
    3 Eric
    4 Pete


    I tried to create queries, one for User1 and another for User2, and then join them with a third query. However I could not remove from the query for User2 the ones that had blank User2's. Any help is greatly appreciated! The decal is not the primary key, it is hidden.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825

    Call it Normalize Data with Union Query

    This would be a UNION query. There is not wizard or designer for UNION, must type in SQL view.

    SELECT Decal, [User 1] AS User, "User1" AS Source FROM tablename
    UNION SELECT Decal, [User 2], "User2" FROM tablename;
    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.

  3. #3
    eizquierdo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    7
    Got it to work thanks! I used the " NOT "" " criteria for my user 2 and then the union and works perfect.

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

Similar Threads

  1. ODBC Call Failure
    By askjacq in forum Database Design
    Replies: 3
    Last Post: 01-16-2013, 02:06 PM
  2. Use VBA to call stored SQL from table
    By hcruz in forum Programming
    Replies: 2
    Last Post: 05-02-2011, 08:26 AM
  3. ODBC--call failed
    By TCB in forum Access
    Replies: 4
    Last Post: 04-28-2011, 08:23 AM
  4. Call Shell() syntax
    By jgelpi16 in forum Programming
    Replies: 6
    Last Post: 03-07-2011, 02:56 PM
  5. how to call a sub procedure?
    By dollygg in forum Access
    Replies: 1
    Last Post: 08-18-2009, 05:10 AM

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