Search results

it turns out when you initially load the Power Query you have to load it as connection only and not to the data model. then in the workbook queries panel, you load it to the data model from there. then it will appear in Power Pivot

For some reason I am unable to load data (connected to Oracle) I've modified with Power Query into Power Pivot. From Power query, I created a connection to the data model only. From Power Pivot I then try to load it from "existing connections" This is the message I get: "The connection you’re...

The characters are of all kinds, from chinese to korean to random symbols: Email 팀* 팀* �* �* �* �* �* �* �* * * * * * * * * * * * * * * * * I noticed that this only happens when I include a field from a related table in query...

I'm querying a field in a customer table that contains customer email addresses. The output does not return the hyperlinks actually in the customer table though. Instead, I get a singular foreign character of unknown origin. How come this is happening? What can I do to fix this? Thank you!

For some strange reason, it no longer exports more than ~65,000 records anymore. I'm exporting a saved query to excel and unchecked the formatting box.

The various containers (etc jar)and types (meat) are not unique in any table. The productID in the Products table features different spellings of potentially identical products from distributor reports I receive. (i.e. Apple Bag- 16 Count; Large Apple Bag). These productIDs are unique, but both...

How exactly would you determine the selling price of a bag of Product X to distributor John in this transaction? The $8 price per bag is a set price for John that I decide and would be stored in the DistrbCost table. Container: Bag Type: Fruit Distributor: John Unitcost: 8 John's order of 2...

1 unit is some combination of container & type could be a jar of fruits, or a bag of meat. I might charge Johnny Distributor $5 for a jar of fruits, but charge Mick the Distributor $7 for a jar of fruits.

G'day! I want to store the unit prices I sell my products to distributors for. I have distributors to whom i sell my products to. Prices for products vary depending on Container (i.e. bag, jar, case etc) and type (fruit, vegetable, meat etc.). In addition, sometimes the prices vary depending...

Th Doc Man is totally right. Saving it does the trick. The tutorials I read didn't specify to save it first. Thanks Doc!

I'm trying to export more than 65,000 lines from an access query to excel. Here is what I tried; External data->export->excel -> uncheck "export data with formatting and layout"; format: xlsx, filename: C:\Users\Jimbo\Desktop\Query1.xlsx Upon running it, I get a prompt: "the microsoft...

Let's say I have a customer table. When I query multiple names using wildcards, I'd like to group the matches together rather than show each distinct match. i.e. criteria:"*Jim*" or "*Bob*" Result: Jimmy, Jimbo, Jimmo, Bob, Bobby, Bobo Desired Result: Jim, Bob Is such a thing possible?

I've tried putting "*" & [fieldname] & "*" in the "field" section of the query designer

Let's say I wanted to make a table from an existing table. In the new table, I'd like all the records from the existing table, except I'd like to supplement them with one asterisk in the beginning of the value and one asterisk at the end. Is this possible to do within a Make Table query? Thanks!

I have a list of new customers that I want to add to my Customers table. The primary key is Name. I cannot add the names from the new customer list with an append query, but when I manually copy and paste them into the Customers table directly it works. How come this is happening? edit:i...

it didn't work exactly as you wrote it but i was able to use o.OrderDate>Date()-365 to approximate the effect I want. Thanks!

Hey y'all, I figured it out, the code below counts the unique months from the Orders table and summarizes it by AccountNumber in the Stores table for the year 2016: SELECT ccsym.accountnumber, Count(*) AS NumDistinctMonths FROM (SELECT s.accountnumber, year(o.ordermonth) AS yyyy...

High level overview: I sell products to customers. There is a Stores table that contains customer details. Sometimes the same customer will appear twice but under a slightly different spelling (StoreName). These duplicate customers are aggregated with an Accountnumber. When a customer makes an...

Please see attached, it's more complicated because rather than counting the months for each customer in the Orders table, I'd like to count the months for each AccountNumber in the Stores table.

There's only one account number per customer i.e. Customer/ AccountNumber Jack Jones/ 101 Jack. M Jones/ 101 Jack Maury Jones/ 101 Jill Frost/ 102 J. Frost/ 102 Mike Nox/ 103