queries

hello All, I have many merged and appended queries. When ever I delete a related query it pops up that I can't delete because its dependent or merge with another query..Now how do I know and differentiate all those merged and appended queries? same as in Microsoft Access the relations are shown...

I have an SQL report that I download each week that shows the details of each invoice that week contained some type of error. That could range from we had to send a substitute product in place of the one that was ordered to a driver that didn't load a pallet on a truck and did not make the...

I have a list of values (Column A). Against each value, I want to know the last 5 values that are below zero from that row onwards. For example: I want queries in Columns C to G that I can drag down. As the query drags down, I want the values to appear. If this helps, the values in column...

Hi all, I've done a few searches for this, and while others seem to be having the same problem, the causes seem like they might be different. I'm trying to connect to a union query in Access from Excel (both on Office 365 and updated). I built the two different select queries separately as '1'...

i'm trying to learn how to use Access efficiently. I do know that it does have several types of queries. I've used the update append, simple and delete query What is the rule of thumb for creating Make Table queries and delete queries. Are delete queries normally used to clear existing tables...

My goal here is to open files in a separate folder, run the macro in each file, close and save it. The macro in that workbook updates 15 power queries. The Code Completes The Loop and opens all files, changes the value in A1 and saves them. It however is not running the macro from the other...

I have a workbook with several queries to an external db. For all of them, I let Excel save both UserId and Password (not a big security concern, at the moment). Quite often I need to run the same set of queries against different db schema, that is, by logging in using different UserId/Password...

Right now I have a button that refreshes multiple queries over multiple worksheets in the same workbook. These worksheets are all protected and my macro will not update those queries due to the protection. I added a two additional buttons to unprotect all sheets and protect all sheets. Can I...

I have several tables in separate workbooks that different users populate based on the stage that a project is in. MainTbl: holds basic info on a project QuoteTbl: info on status of the project's quote info EnggTbl: info on engg for projects FabTbl: info on fabrication for projects AdminTbl...

Good morning, I have multiple tables feeding to any of my queries. When I export any of my queries that contains a memo field to excel the cells are being truncated. Many of my cells have 10,000 characters as an average. I have hundreds of queries that are specific to what I need to export...

Hi All, I was hoping someone could give me some feedback on the following: I'd like to create a ticketing system/query log of sorts x 4, to track queries that I am getting. At the moment I am having to copy and paste all the details from an email in Outlook into an Excel file, to log the...

Hey all, I recently began converting all of our firm's Access databases and Queries to SQL Server due to size/efficiency/etc, and I was hoping someone could recommend a better way for me to complete this process. For each of our clients, we receive monthly or quarterly data files (usually in a...

I'm using Power Query to load 10 tables to the data model. I noticed that my workbook has a PivotCache count of 4. Is it normal for PowerPivot to generate multiple caches or have things gotten duplicated? Is there any way to find out which queries each cache relates to? If I try...

Hello, I have several excel pivot tables that use ACCESS queries that I have created as the data source and they work great. Is there any reason I would not be able to see some of the queries I have created when I am creating a Pivot Table and select 'Use External Data Source'?? I have...

If I have 5 Power Query queries that load to the data model, within the Data > Connections window, I see a list of each query as well as ThisWorkBookDataModel. I am writing a macro to refresh all the queries in my file and wondering if I need to refresh all the PQ queries AND...

Hi Team, I have a created a data in Table as base file and with the help of this i have created too many queries as per my need. But I need to replace the source data file with additional changes without affecting queries There will not be any changes on the existing data, but there are...

Hi Guys, I have two queries relate to Excel VB. Hope to get a solution soon based on your expertise :) 1) How to add two codes simultenously in VB. 2) Need to delete a specified row in excel that contains For Example: Column B containts text "Total" and I am looking for a code that delete...

hi all I have put 3 pivot tables on one report which are created from a query with criteria to input to and from dates which work however when I run the report it asks me to enter the dates about 15 times. my questions is this... is there away I can link the criteria question so the I can just...

I have the following formula on the first tab of my workbook: ='Original Contract'!C$2 The cell C2 is part of a query that gets refreshed when my macro runs. The query only ever has one row plus the header row. It is never blank. The data just changes depending on which job number they are...