query

Hello, How can I rename a query (not its shortcut)? I've a query that is part of a 'Group' under 'Custom' category in Navigation pane. When I right click on the query I see option of renaming the shortcut. How can I rename the actual query (not only the shortcut)? I am using MS Access2016...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

Hello, I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the...

Hello All, I am completely new to access and was trying to do this with Excel Power query and was successful however the data is so large that it is taking forever to run, so I decided to give access a go. Here is the situation, I have 10 locations I manage and each day I receive a csv file for...

This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...

Hi There i am new to using MS Query, i think this should be a very simple answer. I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number. I started by doing Like 'W%' which works for the first part. How do i then edit...

Hello, I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel...

Good day, I would like to solve this problem using formula, query, or pivot. My company is issuing invoices. Most of them charge audit service fee and outlay together, and a few of them only charge outlay. I cannot think of a logic to distinguish them in the format I expected. Please help.

I am using the query function with 3 different ranges within 1 formula, Where i want to Select a column if Column X = to a 'Name'. The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name. I am...

Hi Folks, I am stumped. I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on some records for no apparent reason. The duplicates are identical in every way. I followed the steps...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

Hi All, I am using Mac and my team is using windows majorly. We have excel where windows user are able to see the data without any issue but i am getting #REF! in most of the cells. Weirdly , when i opened another excel which is connecting to DB and getting the data and then opened the above...

I'm trying to import txt files into excel. All of the text has the same pattern. That's why I want the content of each file to be in a single cell, so later I can use "Add column from example" to extract the piece of information I need. However, the content was imported into multiple rows for...

I need to load records from another excel file into another based on a range of characters. The user can enter the first and last into two cells with corresponding ranges (firstone, lastone) From these two values, I need to do a power query to load in the data where the customer name is in...

Hi all, I've searched around but can't find any instance where this problem has been solved. I've got some queries set up in Excel (2016) that get stock data for the day from a website. Typically I'll open the workbook and hit refresh all, and the data loads. Today, though, it's loading...

I have a spreadsheet that is basically a trimmed down version of my master that gets distributed. To trim it down, I have removed columns and implemented conditional formatting for readability. Needless to say, very complicated (mostly due to the conditional formatting giving the reader pretty...

Hi everyone, I have a query table in my spreadsheet. I added a column and put "No" in every row (See attached picture for a simplified example). So when the query is refreshed and add more rows, new rows will also have "No" as their starting value. And that's exactly what I want. Then when the...

MS Excel 2016 This is the first time I've used a query, so I could very well have constructed the applied steps incorrectly. My problem is that records from newer files are not present. The query is designed to compile lists of reviewed records from weekly reports. They are the same lists...

I would like to use our case details listed on a spreadsheet to allow staff to enter one or more criteria and have the details of all relevant cases show up on another tab. I have attached a sample of the type of information recorded. If possible, but not a requirement I would like to query...