Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: Query Question!!!

    Hi - I'm new here and hopefully this question will be very easy to answer for some:

    I have a linked Excel table from which I am running a query. My problem is, that I want my query to return values with the criteria that 5 columns in my table contain - that is, there are 5 columns in the table each that could contain the word 'YES' in it, and I want the query to return data for all columns that contain YES.

    I tried using the criteria of having 'YES' as my criteria for all five columns, but then the query is looking for only those fields that have YES in all 5 columns, and doesn't return the values for those that have YES in maybe 3 columns.

    Do I need to use expression builder? Any feedback would be appreciated!

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Stagger your "Yes"s in the multiple Or: lines in your QBE Grid, right now you have them all in-line on your Criteria: line.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    Good call - works like a charm now!

    Thanks a lot!

Posting Permissions

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