Ms Access Create Table From Pass Through Query

i'm having problem with create table query, with variable table name. The story so far: World Travel Inc. Instead of having wooden legs and being used for meals, Access Tables are a grid made up of rows and columns. Open new query and select the pass-through query from the Showe Tables dialog. In the New Query dialog box, click Design View, and then click OK. Use variables in Access pass-through queries by Josh K | March 8, 2006 6:55 AM PST I have an Access 2002 database in which I'm trying to create a pass-through query. Essentially, it opens a linked server, then executes a query as if executing from that server. The only hint I got was using Me. Access will assume the Customer table fields should be placed in the new form because it is selected. Through this blog an attempt has been made to give an apt answer to the queries such as how, why and when to export data items from MS Access database into MS Office Excel spreadsheet. lhamt1 balance, h. This Recordset is not updateable. I tried on MS SQL, it worked for me. The SQL Azure administration site also allows you to create your database and users, but you will need to use SSMA or another SQL management tool in order to create your tables and other database objects. adp files, were introduced to provide an alternative to using ODBC. This article is Part 3 of the Microsoft Access tutorial. Pass-through query with ReturnsRecords property set to True did not return any records. MOS 2013 Study Guide for Microsoft Access Published: June 2013 Demonstrate your expertise with Office! Designed to help you practice and prepare for the 2013 Access Microsoft Office Specialist (MOS) exam, this all-in-one study guide features full, objective-by-objective exam coverage, easy-to-follow procedures, and illustrations to review essential skills. You must tell Access that this is a trusted database before it will accept a data-definition query. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. Click Close in the Show Table dialog box without adding any tables or queries. After this table is created, can you run another pass-through query with. You may have experienced Microsoft Access query timeout. I have to export data from SAP Tables (Eg: BUT000) to Excel. By relating the two tables through the common customer identification number field, the Creating a Query with Tables and Criteria. To use the Linked Table, create a query in Access that references the Linked Table, and connect to the Linked Table through the query in the OLE DB connection. If you would like to follow along, you'll need to download our Access 2016 sample database. com tables (objects), run: EXEC sp_tables_ex @table_server = 'SALESFORCE' Pass-through query in an OPENQUERY function. Any references to forms or controls on forms in a pass-through query are meaningless to SQL Server, so you must pass the actual values for your parameters. OpenArgs argument variable it is possible to pass values. I just want to select a table name from the combo and then click a command button which will generate a pass-through query to remove all data from selected table in the combo. Each level is effective for a specific scope of queries. Supported Features in Access. Pass-Through queries are coded in the dialect of the back end database. Suppose that you are. What I need to do is to create a query that selects from the linked Oracle tables, and also calls the VBA function above to retrieve the result from the SELECT pass-through query (this SELECT pass-through query, and all others I use for this project, will be invoking Oracle functions that return only one scalar value like a number, string, or date. Description Your training and experience using Microsoft® Office Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. My usual approach is to create and save the pass-through query, then create a second query which uses the pass-through as a data source and does the append. The following screen shot formats the display columns. You can use forms to control access to data, such as which fields of data are displayed. If you do not have a MS-Access environment, start by installing the required software and create a test table. Using simple SQL commands, you can create tables, queries, forms, and reports. There's one set of queries for each table, a delete, a pass through, and an insert. Learn from the example of sending email using Outlook. I have to export data from SAP Tables (Eg: BUT000) to Excel. Tables are the foundation of an Access database. I am trying to build a pass through query in Microsoft Access. When creating a new Excel Data Query from Access, the parameterized Access-side queries are not even shown in the list of "table and view tables" in the second step for creating a Data Query. This video covers the basics of creating and working with pass-thru queries. in MS Access Forms MS Access Queries MS Access Report MS Access Tables MS Access. The screen shot below shows the Query Builder in action. How to create a "linked table" to an existing Oracle DB schema. I use this method quite a bit because of how frequent an email distribution list can be changed in the workplace, along with the fact that just about everything I […]. To combine records from tables or queries by using the union query, you need to know its rule-- the tables or queries that you want to combine must have the same number of columns, unless the union query cannot execute. Actually I have so many link table which connected to backend SQL Server by ODBC. With care. MS Access - Between Dates queries using variables from forms by sheilasabado | June 13, 2010 8:05 PM PDT I have a table with [Call Start] as Date/Time General Date which has data from March 30. lhposj BETWEEN 2012336 and 2012366 When I run the query I get a message that file LNP007 in BNKPRD01 has more. Step 1: Check if the Sybase ODBC driver is installed on your PC. Just wondering if any one can help me out. But today, we're going to use Query Design to create a query. SQL queries are those that are created using the various SQL commands like SELECT, DELETE, UPDATE or APPEND. MS Access - Between Dates queries using variables from forms by sheilasabado | June 13, 2010 8:05 PM PDT I have a table with [Call Start] as Date/Time General Date which has data from March 30. Microsoft Access is a lightweight database tool that allows you to tap into greater power on your data with minimal effort. In the New Query dialog box, click Design View, and then click OK. Learn from the example of sending email using Outlook. I tried with pass through query but it is taking more time to import even I tried with recordset object also eithder were didn't work out. I created a new append query in Access Design View using the pass-through query but it runs really slow. Many other applications offer this feature as well. I have created a parameter query using Microsoft query as mentioned here. It may take some time, depending on how large the data table is. It is one of the SQL-specific queries, which can be created only using SQL view. Hi Friends, I have 140000 records in a oracle table. Access has the ability to create subforms. Please help me. which is a real-time representation of the underlying tables. First, here's an example of the results of a crosstab query. If you'd like, open tblClients in design view so you can see the field names while typing. Connect to Data Warehouse server in Microsoft Access, and link desired Data Warehouse tables into MS Access. While executing queries directly and receiving data directly in this way is not bad, there are implications when trying to join the results of OPENQUERY with a local table. Open new query and select the pass-through query from the Showe Tables dialog. Use the CREATE TABLE statement to define the table in SQL. You can get it to create a new table based on criteria and save it either in the current database or add it to another Access. Re: ODBC Pass-through. Open Microsoft Access 2003, create a new mdb and click on the Queries Object and select New-> Design View query as shown below, then press OK. Choose the file to be imported, and click the "Import" button. MS Access - Create Tables - When you create a database, you store your data in tables. Access VBA loop through Table records. Hi Friends, I have 140000 records in a oracle table. Pass-Through queries are coded in the dialect of the back end database. If I type out my T-SQL in the Pass-Through query editor, it works just fine. What you will see next is a query screen that looks something like what is presented below. There are a lot of reasons that you should NOT go this route. Unfortunately, in the default configuration of recent MS Access database releases, these tables are not accessible. The request was: “At the moment I am building a database for … I have a table holding information of the product, user, email address and balance field. If you're creating a particularly nasty SQL statement or are a bit rusty on the SQL syntax, you may want to click the Query Builder button. Hi Friends, I have 140000 records in a oracle table. Use pass-through mode for the query instead of using a table link. in MS Access Forms MS Access Queries MS Access Report MS Access Tables MS Access. Just run a Select Into (or make-table) query, based on pass-through query. I have to export data from SAP Tables (Eg: BUT000) to Excel. How to Use MS Access Forms to Pass Values to Queries. Access will present a blank SQL view. As you can see, both the built in Excel SQL query and the VBA method have pros and cons. At the end I query the table for th Using Pass-Through with a Temp Table - Microsoft: Access Queries and JET SQL - Tek-Tips. In the New Query dialog box, click Design View, and then click OK. It is not compatible with the Python DB API interface. Hence, the present blog goes into the complete detail of exporting data items from MS Access to Excel worksheet. After creating the database file; just write the following line of code to create the table in MS-Access. To create a linked table:. Access VBA for Non-Programmers. Union Query Example Any/All as a Choice in a Combo Box. plz provide an example that can make me understand. The JAMstack (JavaScript, APIs and Markup) revolution is in full swing. Record in table was deleted by another user. Can a pass-through query to create a table?. Go to Start > Control Panel. The following illustration shows the Database Container: Using Databases You have collected data using a web-based survey and wish to tabulate the results. There are two main categories of query types in Access -- Select and Action queries. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP. This technique is often used for selecting specific (or All) records for a report. The Type argument values are specified by a number of constants. source a pivot table in Excel from Access). Change Query criteria. ries, multi-table, multi-field, complex joins are handled much faster with a pass-through query. "ReceivePaymentToDeposit" table does not support TxnID filter in QuickBooks SDK & due to this issue happen. You can use forms to control access to data, such as which fields of data are displayed. They know and demonstrate the correct application of the principle features of Access 2016, and they demonstrate the ability to create and maintain basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries. In order to import data into an Access table, open the database window and choose the File Import from the menu at the top of the screen. Run the insert query to repopulate the local tables (the insert gets its data from my current pass through queries that run against the AS400). Select the file format and click "OK". Designing Forms in Access This document provides basic techniques for designing, creating, and using forms in Microsoft Access. Because queries save time and make your workflow more efficient, it's important to understand how to create and utilize them. Recordsets have many methods and properties to make working with the records in the collection easy. Can a pass-through query to create a table?. I loved the site. So the ideal world would look like this: In Access I have a bunch of queries which rely on parameters to do their work. Using VBA-generated pass-through query definitions to grab data as needed, no linked tables and no permanently saved queries. A Microsoft Query (aka MS Query, aka Excel Query) is in fact an SQL SELECT Statement. " For the details on creating multiple-table queries using SQL, see "Using SQL with Multiple-Table Queries. How to insert data into access database from a html page asp. Access will present a blank SQL view. You can use a make-table query to create a new table from data that is stored in other tables. To use the Linked Table, create a query in Access that references the Linked Table, and connect to the Linked Table through the query in the OLE DB connection. Commonly used naming conventions (Taken from [email protected] Run the insert query to repopulate the local tables (the insert gets its data from my current pass through queries that run against the AS400). step is to actually run this query to make the new table. Table constructor is not a function in DAX, it is a set of characters which using those, you can create a table in DAX. After creating the database file; just write the following line of code to create the table in MS-Access. Let's suppose that you already have an Access database, and that the Access database contains a query called "max_sales" Here are the steps that you'll need to follow in order to create a VBA to run the "max_sales" query: Step 1: Add an Access Form. Crosstab queries in Microsoft Access allow you to do what normal SELECT queries do not: aggregate data across columns as well as rows. Try odbcDriverConnect through RODBC for 64 bit (sorry, you'll have to find instructions elsewhere). Create a form with this query as its Record Source. Its query feature is used to retrieve data in desired formats. Then copy this into your code (and be done with Query. " For the details on creating multiple-table queries using SQL, see "Using SQL with Multiple-Table Queries. Any Access table, including linked tables from different data sources, can be used in a query. Here are three questions that have been asked of me regarding how to pass a value from one place to another in MS Access: I have multiple queries and need a form for a date to be entered once. Full disclosure: Databases aren't my background (as you will see) however it was my "spare time project" to learn more about MS Access. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Also it shows the example of how to use two tables in one query. So Please help me in quering tables of SAP using VB Macro. It follows on from my last post on How to Create a Parameter Query , but this time we are going to create the form which collects the query criteria. Microsoft Access GUI Building Forms Reports Microsoft Access provides the tools for developing graphical user interfaces that facilitate the use of database applications. This wikiHow teaches you how to create and set up an action query, which is a command that can sort and display data automatically, in Microsoft Access. to create a query dynamically through VBA. Create a make table query. When creating relationships among tables, we were selecting the primary key of one table and the foreign key of a dependent table to join them. This Recordset is not updateable. Learn more about query criteria and expressions. i have tried, but it din't work, as i tried. The screen shot below shows the Query Builder in action. How do I create queries in Microsoft Access? a 3 table through a query in Microsoft Access? down a duplication query in Microsoft Access where it gives me. Static sites are secure, fast, reliable and fun to work on. Never fear, for PHP can easily work with Access databases. However you must ensure that your email sending program supports HTML. Create a Make Table Query. If I type out my T-SQL in the Pass-Through query editor, it works just fine. MS Access - Create Tables - When you create a database, you store your data in tables. If you would like to follow along, you'll need to download our Access 2016 sample database. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. You can actually use a pass through query with any ODBC-compliant database such as Oracle, MySql, SQL Server… passing most any valid T-SQL statement and of course a common T-SQL statement, in the case of stored procedures, is to simply have it contain the name of a stored procedure with. /decompile Undocumented command line. This technique is often used for selecting specific (or All) records for a report. However, this procedure should work with Oracle 8i, 9i, 10g, 11g and 12c databases, as well as various versions of MS-Access. Select the file format and click "OK". Is this possible? If so, which option on the Get Data button should I use? Will this import work for people that do not have ms access. Essentially, it opens a linked server, then executes a query as if executing from that server. Its query feature is used to retrieve data in desired formats. Parameter Queries in Microsoft Access 2013. Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Delete records from one table using join with another table 2009-10-27: Concatenate data ignoring NULL values 2006-03-24: User defined function in MS-Access SQL query 2006-03-24: MS-Access UDF function that replaces special characters 2008-10-08: UDF Min/Max value function in MS-Access SQL 2011-04-08: Build Sales reports using MS-Access queries. Click Close in the Show Table dialog box without adding any tables or queries. This MSAccess tutorial explains the purpose of a pass-through query in Access 2003 (with screenshots and step-by-step instructions). You can also use this query to combine the data from one or more tables into a single table, or to send new tables to different Access databases. To Create a Data Source to an MS Access database (*. So keeping going and happy Access-ing!! Recommended Article. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. Unfortunately, in the default configuration of recent MS Access database releases, these tables are not accessible. Whether in DAO or ADO. ” You can still open them, but to unhide them permanently, right-click on the table you want to unhide and select “Unhide in this Group” Want to learn more about Microsoft Access? See our Microsoft Access Training Courses or view our Microsoft Access Tutorials on YouTube. Actually I have so many link table which connected to backend SQL Server by ODBC. So if table1 had 50 records table2 had 20 records and table3 had 10 records the resulting query would have 80 records in it. The data is now imported from the file and a new Access table is created that stores the data. Sometimes a client will already have a database and ask that we make it available on the web, and sometimes that database is in Access. In the Database window ( Database window: The window that appears when you open an Access database or an Access project. This lesson demonstrates how to use ODBC to connect to a database. Stop Disabled mode from blocking a query. Choose the file to be imported, and click the "Import" button. Create a new select query. On the Design tab, in the Query Type group, click Make Table. In conjunction with a simple code factory template, the Unity transmogrify utility can generate CREATE TABLE scripts that can then be pasted into MS SQL Server or MySql. Create a form based on a table or query using the form wizard. How to create Pass-Through Report in Access 2003 Create a new Query in Access 2003. step is to actually run this query to make the new table. Select the 'Create query in Design view' option on the right pane of the window. How to Create MS Word Documents from MS Access Programming a dialog with the Access VBA (Visual Basic for Applications), used in all of Office to write macros, you can also export data from one or more tables to a Word document using a template with form fields. The hosts can gain input from the guests and enter it to the database and this has a variety of applications. If you want to write a query against one or more tables, click here for the additional instructions. Esteemed Forum Participants and Lurkers: ===== MS Access, remote Oracle Database NEWBIE ALERT! I am trying to create a table based on a one-time Pass-Through query snapshot of an Oracle database. If you open a Microsoft Access recordset on a local table, the default is a Table type. Create a form with this query as its Record Source. Let us go to the Create tab again and click Query Design. This technique is often used for selecting specific (or All) records for a report. A table contains rows (or records) of data, and each row is organized into a finite number of columns (or fields). Empower Your Microsoft Excel Skills. What you will see next is a query screen that looks something like what is presented below. The Simple Approach to Creating Microsoft Access Subforms. The following code examples demonstrate how to open different types of recordsets. lhamt1 balance, h. It can be done through the following steps: Start Microsoft Access and open the database containing the query that is to be converted to MySQL. A popular way to let end users search for information is to provide a form with many combo boxes on it which have drop down lists of data from a table or query, then to base a query on the values in those combo boxes. When the Show Table window appears, click on the Queries tab. com tables (objects), run: EXEC sp_tables_ex @table_server = 'SALESFORCE' Pass-through query in an OPENQUERY function. A Pass-through executes SQL directly against tables in an external database (such as Oracle, Sybase or SQL Server). Speed up pass through query I have an Access database that I want to use as a backend to an Excel file (e. Create a form with this query as its Record Source. Executing a Pass-Through Query Saved in Access: 2. Creating a form through MS Access Form templates doesn’t require much technical expertise. You can also use SQL Queries. Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Union Query XV. The target audience for this guide should have general database management knowledge and experience in composing SQL queries. Next you must create a query since the query name will have to be referenced within the form. Access provides several methods for creating a table. Click on Close when you are prompted to add a table. In this example we will demonstrate the use of an extended select list box as a method to pass parameters to an Access query. The trouble is i cant seem to run it straight from my query (140 records) it just keeps running and eventually access is “not responding” and i have to force shut it. Record in table was deleted by another user. Finally, let's put together a query that joins together data from 3 tables. Each level is effective for a specific scope of queries. For demonstration purpose, I have made four tables and a query, as shown in the screenshots below. I searched everywhere to find out a way to pass values but couldn't succeed. Click on the Start button, point to Settings, and then click on Control Panel. If you open a Microsoft Access recordset on a local table, the default is a Table type. Click close in the Show Table dialog box without adding any tables or queries. PASS-THROUGH queries Used when linking one database to another through an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity or Sun Java standard) connection. I am trying to retrieve data from a file that has multiple file formats. In particular, characters 128 through 159 as used in MS-Windows are not part of the ISO-8859-1 code set and will not be displayed as Windows users expect. To combine records from tables or queries by using the union query, you need to know its rule-- the tables or queries that you want to combine must have the same number of columns, unless the union query cannot execute. It 's able to do transactional operations in an "all-or-nothing" fashion, just like any other mainstream DBMS systems out there such as Oracle, MySQL, SQL Server, etc. The make table query is really useful for backing up data in Access. Lesson 2: Creating Microsoft Access Tables. An Access GUI consists of a set of Forms. org to databases such as Microsoft SQL Server, Oracle, Salesforce. which is a real-time representation of the underlying tables. Because queries save time and make your workflow more efficient, it's important to understand how to create and utilize them. If I type out my T-SQL in the Pass-Through query editor, it works just fine. Example of using a Criteria in Query. Create a query using the Access Query Designer (Create Tab > click Query Design). Once you've done that you can create so-called "linked tables" inside MS Access and then insert the data of your queries into these linked tables (can be done with an "append query"). Hi everyone, first time authoring here and looking to pass on one of the neat, but less intuitive aspects of data management in Excel. Click on the Start button, point to Settings, and then click on Control Panel. Open new query and select the pass-through query from the Showe Tables dialog. In the New Query dialog box, click Design View, and then click OK. When entire tables have to be brought into SAS, the processing is slow, taking up lots of resources and space. There are three basic steps that are necessary: Create the form with the combo box(es) that will supply the parameters for the query. Create a new table from columns from existing tables In MS access I would do a make table query taking the data from TS1 and then an append query using the. The following code examples demonstrate how to open different types of recordsets. Table is read-only. MS Access 2003: Integrate with Append Query How to Integrate a Pass-through Query with an Append Query If your table already exists in Access, but you need to move the data from the external database into this table, you can create an Append query that uses the pass-through query as input. If I type out my T-SQL in the Pass-Through query editor, it works just fine. In Access, create a new blank database and delete the default blank table. The database. In MS Access and all the other database management systems, queries act like the pillar of the software, which can perform various actions to make your database more organized and operational. Step 1: Check if the Sybase ODBC driver is installed on your PC. Here are some ways which can be done to Find and Remove Duplicates MS Access Query: 1. This article describes how to dynamically change a SQL Passthrough query and a local Access query. Because other database objects depend so heavily on tables, you should always start your design of a. You can use this query to send commands directly to the database server. Outer Join is the SQL function to join two tables (or multiple tables), then return a set of query records including what inner join would return. Hi everyone, first time authoring here and looking to pass on one of the neat, but less intuitive aspects of data management in Excel. So today will learn how to read these table cell value (TD value) using jquery on row selection. To create a table in MS-Access database, first of all you've an existence database file or you have to create a new database file. I wanted to create a single pass-through query that will combine both deleting/truncating the oracle table as well as append the new records. This technical note explains how to create a SQL pass-through query in Access 2003 and 2007. Pass-Through queries are coded in the dialect of the back end database. Creating queries with the Simple Query Wizard is the easiest way to create and deploy a query in Microsoft Access. The ODBC standard supports a subset of what can be done in Microsoft Access: You can use SELECT queries and/or tables as data sources, include subqueries, linked tables, and cross products/cartesian joins. However i managed to get my dsum to work. Each row represents a different city, and each column represents a different. The screen shot below shows the Query Builder in action. The query can then be used directly or used as a data source for a report. This lesson demonstrates how to use ODBC to connect to a database. to create a query dynamically through VBA. When I have to write a pass-through query with multiple joins, I use a shortcut that helps me write it. How do I create queries in Microsoft Access? a 3 table through a query in Microsoft Access? down a duplication query in Microsoft Access where it gives me. This walkthough and sample database will show you how to use. Learn more about query criteria and expressions. I am trying to create a new table to an existing DB [MS access (. Access and SQL Part 6: Dynamic Reports. If you did not understand. This is a deal-breaker for my use case. Once such a relationship is created, you can create a query that combines both tables to create a set of records, also called a record set, or a Recordset, that would include either all records or. From Excel those parameters should be taken from given cells. A make table query retrieves data from one or more tables, and then loads the result set into a new table. You will need to tell Access what fields relate to what other fields in the separate workbooks. Even before this it was possible to write XML from Access by using VBA to write it out as a text file, or by setting a reference to the MSXML or MSXML2 library and build the document. There are a lot of great reasons to start using Power Query to manage your spreadsheets. On the Design tab, in the Query Type group, click Make Table. Pass Through Query + Make Table Query Combo (No Linked Table Approach) There is no direct way to download SQL Server data into Access using code, you can’t use a ADODB recordset or command to download the data, since they only “see” the SQL Server side and don’t have exposure to your Access data. In particular, characters 128 through 159 as used in MS-Windows are not part of the ISO-8859-1 code set and will not be displayed as Windows users expect. Access also supports the creation of "pass-through queries". February 22, 2015 at 5:41 pm. Use pass-through mode for the query instead of using a table link. When I have to write a pass-through query with multiple joins, I use a shortcut that helps me write it. However you must ensure that your email sending program supports HTML. In this lesson, you will learn how to create a simple one-table query. Note: It is possible to use Linked Tables in Access. Select MS Access Database* and check 'Use the Query Wizard to create/edit queries'. Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. Microsoft Access. Linking tables on fields is done visually by dragging a line between the fields to link. Create a query. To work around this problem I need to send pass through query to MySQL and have query run directly in MySQL. ReturnRecords = True which contains only SELECT * FROM #aSpecialty? BTW, if the content of this query isn't going to be changed, you can create a stored procedure with all these actions. In Access, create a new blank database and delete the default blank table. Static sites are secure, fast, reliable and fun to work on. You can use forms to control access to data, such as which fields of data are displayed. The story so far: World Travel Inc. But I dont have Edit access in SAP only thing is I have view access i. The Type argument values are specified by a number of constants. Microsoft Access Help Database Forums and Wiki by UtterAccess Would Access Affect SQL Server Performance By Running Heavy Query From The Linked Tables?, Access 2010. TO 'testuser'@'localhost'; Query OK, 0 rows affected (0. com ODBC driver. In the Database window, click Queries under Objects, and then click New. On the Design tab, in the Query Type group, click Make Table. MS Access MS Access Queries MS Access VBA Programming 3 responses on " MS Access - VBA - Run Parameter Query in VBA " joshua E. Even before this it was possible to write XML from Access by using VBA to write it out as a text file, or by setting a reference to the MSXML or MSXML2 library and build the document. Creating the Query to Reference the Form Control. It is not compatible with the Python DB API interface. It is initiated by specifying OPENQUERY as the table name in the from clause. Union Query Example Any/All as a Choice in a Combo Box. I'm certain you can do pass-through queries without the Access Query Builder.