Results 1 to 2 of 2

Thread: Union Query

  1. #1
    Join Date
    Sep 2004

    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?


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    -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 | @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