-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
paramater
-
J
PowerQuery - Pass Parameter from Cell Value replacing Variable from T-SQL Script
Hi All, I am new to Power Query and I'm seeking some assistance. I have a script that I have created within SQL. Within the script, I have DECLARE'd and SET a variable for a 'Report Date'. This variable is used throughout the query and various date fields use this date. Previously, when I...- JonReyno
- Thread
- dax paramater powerquery t-sql
- Replies: 0
- Forum: Power Tools
-
S
Enter Parameter Box Help
On a Form, I have a button to open a different form based on the current URN displayed. The code is below: Private Sub Button1_Click() DoCmd.OpenForm "frm_01", , , "[Company URN] = " & Me![Company URN] End Sub This code works but everytime a user clicks on it, an 'Enter Paramater Box' appears...- SantasLittleHelper
- Thread
- error form paramater validation
- Replies: 1
- Forum: Microsoft Access
-
D
Excel AS400 ODBC Parameter - Comma Separated List
I am connected to an AS400 database using Microsoft Query iSeries ODBC. I want to use a parameter and allow the user to put in a list. i.e. where x.Store NOT IN (003,006,008) I tried entering a parameter (?) here, and referencing a cell, but I keep getting a length error. How do I allow the...- Delfinus25
- Thread
- commas odbc connection odbc query paramater sql connections
- Replies: 0
- Forum: Excel Questions
-
K
excel query pass cell value as parameter using begins with criteria
Hi, I really hope someone can help me out. I am trying to use a cell value as a parameter1 in a query that extracts data from a database. I need to use the begins with as the filter criteria. I have no problems with using the "=" as the criteria, but not sure how to use the "begins with"...- kpbbbb
- Thread
- begins with paramater query
- Replies: 0
- Forum: Excel Questions
