query

I was wondering if someone can please help me on best way to use parametirized SQL query and bring it to Power Query. I have access to SQL server with known connection string. SQL is long and needs to use specific input parameters (project numbers) in it. I don't want to have them changed each...

I have a query that retrieves information from multiple excel files in a folder The problem I am running into is that those files have formulas that depend on the current date Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first This results in incorrect...

Hello, I am working on a worksheet where I copy data from an Access database which then I want to sort alphanumerically; as in letters on top and then ascending numerical values. The query I'm using is: SQL = "SELECT Material, Description, Qty, Unit, Amount, Currency, Batch, PO " & _ "...

Hello, Can you please help me find a workaround to load needed records Is there a way to replace #REF error, but keep #VALUE one ? Or in other way, Is there a way to load #REF records , but exclude #VALUE ones ? If it helps I use the following formula in order to find keywords. And result...

Does anyone have a walkthrough on how to create a combo box with a subform query that is placed into a form please? Trying to get the combo box to search two different fields in the form but it isn't working for me and I guess I need to start from scratch on this one?

Goal: scrape data from ~300 web pages (of identical format), each with stock market data for a different symbol. I currently use VBA that uses Excel's built-in Web Query tool to loop through all 300 URLs, pulling the data from each as it goes. Problem is that it takes ~5 minutes, which I want...

Hello How do I execute the following code in Power Query? =IF(COUNTIF($B$2:B2,B2)=1,1,0)

When I have a Form based on a query, I am able to filter based on a Combo Box (Use the Combo selection as Criteria in Query). If you have a Form with its source being a Table, is there a way to filter the data? I only want to see records where [Status] is "Active"

Hi, I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...

Is it possible to add the User Name to each record that's being added to a table? I am using an Append Query to add the new record(s). I thought I could create a field in my query to do that, by what I am trying doesn't work CreatedBy: Environ("Username")

Hi there I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to...

I created an Excel workbook that uses ADO query a database on our SQL server: Set myConn = New ADODB.Connection Set myRS = New ADODB.Recordset strConn = "PROVIDER=SQLOLEDB;DATA SOURCE=db_server_name;INITIAL CATALOG=database_name;INTEGRATED SECURITY=sspi;" myConn.Open strConn...

I have a query that I want to have a dynamic criteria based on what someone selects in a Combo Box on a form (the Combo is in the Header Section) Like [Forms]![frm_Add_Supplier]![ComboVendorASL] But when I try to run the Query, I get a pop-up that asks me to "Enter Parameter Value". Not sure...

I a MakeTable Query. I want to add an AutoNumber field to that table after the query is run. Is there a way to do that using VBA? tbl_vluVendor_MakeTable FOUND THE ANSWER: CurrentDb.Execute "ALTER TABLE tbl_vluVendor_MakeTable ADD COLUMN ColumnName COUNTER" Thanks!

I have a combo box on a form. It is based off a query SELECT [qry_vluVendorAddress].[VendorName], [qry_vluVendorAddress].[VendorID], [qry_vluVendorAddress].[CityName], [qry_vluVendorAddress].[MailState], [qry_vluVendorAddress].[CountryCode] FROM qry_vluVendorAddress ORDER BY [VendorName]...

Hey All I've built a Query that pulls in details about certain products in our range. The problem I've got is that the details for each product live in a text file, it contains details for every product we've ever stocked including some obsolete ones. Because of this my Query is returning...

Is there a way to append sort-able table columns to data queries? I can mock up the table as seen in the following, but if I apply a filter to the newly created "NOTES" column and subsequently refresh the table it destroys the row relationship as the "QUERY" column in A is effectively...

I created a search form with a query in it. I want to be able to use the combo box (which I'm trying to fix currently) and then it will pull up search items. I need your help on trying to figure out how to click on the search item below for it to open the next form and search in that one?

Hi Gurus - Thank you for looking into my problem. Below query works when i execute in MS Access. Its a standard query which i plan to call in Excel using ADO. select * from qryForwardRecon; When the above query is called using ADO in Excel VBA , i get zero records. Not sure what could be...

Hello! There is an "external" ready query in Access with name " ZZ1 " with a single SQL line: SELECT * FROM Tabl1 WHERE TTT=Q; Q – external parameter. If I run this query from Access, the system asks me the value Q, and I enter, for example, “A1”, and the query works correctly. Now I want to...