Search results

Hi Mark, Thanks for your reply. Unfortunately the table relationships are much more complicated than your code considers. There's a separate customer table, containing CustomerName(foreign key is [Orders].[customer]), Address, and AccountNumber. I would like to count the months (in the Order...

That worked scrumptiously, thanks! Now, suppose I wish to count the months for each Customer in the Customer table. What would that SQL look like? I tried to mash it into your code but it's too advanced for me.

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

this is a local file on my own machine

it's a very simple database that only i use. I linked it to excel by selecting the accdb file in Excel's data tab.

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

update: i can update it to another field if y is less than 7 characters with an iif statement in sql update table1 set x = iif(len([table1.[y])>7, [table1].[y], [table1].[z])

Hi Steve, the query worked beautifully. As a followup, what if i wanted to set x equal to another field in table1 if len(table1.y) is less than 7 characters (else criteria) in the same query? Thanks!

thanks for that, it worked splendidly. But i need to change the criteria due to something I noticed in my data: what if I wanted to update x to y simply if len([table1].[y])>7?

I noticed that your query is a select query. I would like it to update x with y where len(x) < len(y). To update it, would i simply put <len([table1].[y]) in the Update Query Criteria? It doesn't seem to work.

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

works swimmingly

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

say i want to query the components used in each parent set AND determine the sales revenue from selling the parent set (order table). Currently, returning the children (Composite table) and revenue (order table) yields the Revenue value repeated for each child in the set. If I could somehow...

is there a way to display the children and exclude their prices but include it only for one row ?

so i redesigned the database to reflect the structure you suggested it it seems to be working. Thanks! There is one thing I noticed Since 1 dining set can have multiple components, when I query the sales dollar figure for dining sets, it repeats the Parent ID for each component that exists in...