query contains

  1. P

    Google Sheets: Query Question.

    Is there a way to use the query function where your reference can have more than 1 possible value? Example: =QUERY(IMPORTDATA(https://website.com/mydatasetURL.csv),"SELECT A, B, C, D, E WHERE C = '"&PossibleReferences!A1:A50&"'",0) Is there a way to do this without putting 50 OR statements in...
  2. S

    Parameter wildcard % query using ODCB to SQL database

    I am using Excel 2007 MS Query with an ODBC database query to a SQL database I have successfully set-up the parameter query. When I enter the full and complete part number containing text, numbers and characters, the query works perfectly. No results are returned when I enter a partial number...

Some videos you may like

This Week's Hot Topics