Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Red face Unanswered: help me please.I need it immediately :(

    I have this sample table and I have to get a result answering true or false weather the Outlet can order or not. I have to get the result by checking the outlet and the day.

    I have this code:

    ("SELECT * FROM TableNumber WHERE Outlet = '" & strTable & "' & COLUMN_NAME = '" & a & "' & VALUES = 1 " )

    but it is not working. I hope you'll gonna help me. Thank you in advance.

    |Outlet |Monday|Tuesday|Wednesday|Thursday|Friday|Saturday |Sunday
    ------------------------------------------------------------------------
    FS100 |True | True | False | False | false | false | false

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Before you work on the ADO version, get the SQL statement working.

    If you normalize your data it will be easier to solve your problem, but that might not be permitted by your users.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Oct 2010
    Location
    Atlanta, GA
    Posts
    211
    Provided Answers: 1
    Quote Originally Posted by Pat Phelan View Post
    Before you work on the ADO version, get the SQL statement working.

    If you normalize your data it will be easier to solve your problem, but that might not be permitted by your users.

    -PatP
    Like PatP said, hard code the values into the query that you know should bring back results and make sure that the query itself is working as planned. Then work in the variables.

    Are you using variables within your sql script?

Tags for this Thread

Posting Permissions

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