Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Union Queries

  1. #1
    New to the CF scene
    Join Date
    Mar 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Union Queries

    I have a union query that consolidates from three parameter queries. I understand that the returned dynaset is not updateable as it is the result of more than one query; however, my understanding is that this should not affect the display format settings of the original tables...but it does. Example: fields that are designated Yes/No (which I have set to display as checkboxes) are displayed in the single queries just as they are set in the tables...but in the union query they are displayed as their corresponding "-1" and "0". If I were the only one looking at the resultant data, no problem. Unfortunately, the data is viewed by several people who are less conversant with Access. Is there a way for me to force the union query to retain the original table formatting and display the appropriate fields as either Yes/No or as checkboxes?

  • #2
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    With 'real' SQL, you can do:
    SELECT CASE WHEN column=-1 THEN 'No' ELSE 'Yes' END AS column...

    Worth trying in Access, though wouldn't be surprised if it wasn't supported

  • #3
    New to the CF scene
    Join Date
    Mar 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks GJay. Unfortunately, you're correct. It is not supported in Access. I appreciate the info, however.


  •  

    Posting Permissions

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