Results 1 to 2 of 2

Thread: Union Query

  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unanswered: Union Query

    I have a Union Query that comes from 2 queries

    In each of the queries there are 8 different yes / no statements

    (One is a completed tasks query and one is an incompleted tasks query)

    When I union the queries I see a -1 and a 0 for yes / no respectively

    Can someone please help?

    v/r
    d.williams

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    -1 and 0 are the values stored in the table by access

    if you want to translate them to Yes/No you can use IIF

    e.g. select iif(mybool,'Yes','No') as mytranslatedbool
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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