Search results

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...

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!

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...

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?

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...

In a sales table showing Customer, SalesProduct, DollarValue, and OrderDate (yyyy-mm-dd). How can I run a query of the number of months a Customer ordered and not the count of the number of dates? for example: Customer 1 ordered on Oct 1, 2016, Oct 3 2016, Oct 5, 2016, Nov 11 2016 Nov 12...

Hi, I have a file which is connected to an Access database. I did not put a password on it. However, when I refresh the Pivot Table (connected to Access database). It prompts me for a user name and password. How can I refresh the table without a password? Thanks!

I have a sales dataset which includes alot of negative values in the 'order' field which represents discounts applied. I wish to calculate the gross amount of sales (ignores discounts). How can I quickly do this without putting the Order field in Report Filter and unchecking all the negative...

I have a table featuring names, sales (called sumofrevenue2), and a date field (called expr1) formatted as Oct-2016, Nov-2016 etc. I need to make a pivot table for each name, show their sales per quarter by year and then show the 2016 quarterly sales as a % of 2015 quarterly sales. I am trying...

I want to update a field (X) in a table to the value of another field (Y) in the same record if the current number of characters in X is less than Y. I tried putting this criteria in Update Query Design: Len([table1].[x])<Len([table1].[y]) but it didn't work. Thank you for the excellent tips...

G'day The company I work for is looking into purchasing ERP & data visualization tools very soon. I am a beginner in SQL and would like a system that, through extended use, eventually develops sound SQL skills. My familiarity with SQL/ERPs/Data visualization is very limited. The company...

Suppose I am querying strings which might have multiple words/names divided by a space or other characters. i.e. Nature's Store, Nature123 Store, Natures Store How would I write in the criteria to return anything with "Nature*" followed by a SPACE and *store*?

Im running a query of customer sales in a particular period A customer can have multiple orders in one period (one order per product) i set the Date field criteria >#7/30/16# I set Sales field = Group By to view the individual order $$s when I go back to query design and only change the...

Let's say I have a product table and an orders table. Product table has fields: ProductID, Flavor, BagQuantity Order table has fields: date, ProductID, OrderID, Quantity, Revenue some ProductIDs sold are actually bundles of individual products i.e." 4 bundle Chip bags: 2 ketchup/2 bbq" there...

let's say i have a sales team whose personnel i must assign to customers based on geographic regions of the customer i.e. Ted sales person is assigned to California, John sales is assigned to Florida each month, i'd like to see how much sales Ted and John generated in there respective regions...

Hi, I have a range of full addresses, there are no common patterns separating city and state. The only pattern is that all the states are always two uppercase characters. How can i search each cell in the range and paste the two letter state in the next column? Thanks!

I made a cross tab query Rows (name, address, state, phone) [table: customer] Columns: (month) [table: order] Value: (sales $) [table: order] when i run the query, multiple rows will appear for the same customer, therefore the sales value of that customer is not summed up for months where it...

Let's say I have a table featuring two fields, [household] and [member]. Each household can have multiple members. Therefore the household field can have duplicates. I want a query that only returns one record per household, but I also want to return 1 member only (any member) for each. How...