query critera

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...

I have data being entered into non-adjacent columns that I want to merge, sum then remove the duplicated name. I do not have a master floor type list to query as there are over 50k types. Example, Floor Tile. There are potentially 5 different floor tile types being entered per row (house) and I...

Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. As part of the Advanced Options while creating that connection I included a SQL query that basically reads: SELECT...

I am looking to exclude a specific item from my query that is based on multiple fields. For example if I have a database of cars, greatly larger than shown below: Make | Color Ford | Red Toyota | Blue Chevy | Green Ford | Black I can't get Access to exclude only red and blue Fords. My...

I am trying to take a text string that will be used as a query in Access from an Excel cell and paste it into a criteria field in query design view in Access. Some of my queries will be lengthy so in Excel I have a character length formula warning me if I go over the character limit in Access...

I am trying to set up a query for reporting purposes. I have a table with activity codes that has two fields [FieldA] and [FieldB] which are linked to one other table each that has rates associated with [FieldA] or [FieldB]. I ran a query by just pulling in the table with activity codes and it...

I have a table query and I have a column called Class codes which contain SK8G, SNOW, VAS1A, VAS3A, VAS3B, and CFL1. I want the query to have a parameter to only pull records with "CFL1". I added my column to the criteria in the query and it was set to equal "CFL1". Then I try to return the data...

Hi there I have the following Query and I want the user to enter Start Date in Excel that will trigger the Query. is it possible to it? SELECT Problems_ProblemLog.EntryNo, Problems_ProblemLog.RejectID, Problems_ProblemLog.ProblemDescription, Problems_ProblemLog.ActionDescription...

Hi there! I have records that are being appended to a new table. I would like to have those records excluded from being used again for 180 days, at which point they can be used again. Essentially, I have an ID and an email address which gets stored in the Make Table. I would need to ensure...

I have an excel sheet that imports data from my accounting programme through a MS Query and ODBC connection. I want to be able to have a prompt when I refresh the data that will add criteria to the query. My problem is that I don't know how to limit the prompt to only show a list of options...

I have a query that returns a Null value if it is empty. I want the field to have a zero in it if it is null. Can I use the Criteria field to write an expression to create that? I need the field to be 0 if it is empty. I have tried IIf(IsNull([Current Month]),0) But that makes my query return...

Hi, Is there a an argument to input into the criteria that will search for any record after a certian date? Thanks in Advance, HeyYouYesYouNoNotYouYou

Hi All, I have two queries, named Population and Debts. I have been asked to give the Population for those that do not have a debt and I'm not sure how this would be done via Access. When I go to create another query based on the queries above and I look at the 3 joins available, I can see...

Hi, I want to write a macro in Access (not VBA) and run various queries with the same criteria. This criteria is however not fixed and requires the user to enter the value. Can anyone suggest me the best way to do this? If I use VBA macro to prompt the user to enter the value once, how can...