Search results

currently in the Order table, there's a Product field (foreign key) that ties to Product Table: ProductID field. If I split the Product table into Parent and Child tables, do both ProductComposite:ProductName and Product.ProductID tie back to Order.Product? Also, let's say Flavor is used to...

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

thank you so much for your help. I only have one more question: how would the AND (Start<=OrderDate) AND (End>=OrderDate) part of the code appear in Query Design?

I attached a picture of the database relationship chart. the [broker] table is supposed to assign [states] to sales people [salesteam].[name]. There are customers/[stores] for which we have [state] data for. Stores make [orders] and the date they order is tracked [orders].[ordermonth]...

What I say next may be very confusing. sales data comes from several external parties that already require alot of manual formatting before it is ready to be imported into Access. Let's say a salesperson (John) is only responsible for Florida from Jan 2016 to April 2016. Is there a way to...

currently i have a customer table only. Should I create a new table with the fields: Country, State, sales person 1, Sales person 2, sales person 3? Then link the State field back to the State field in the customer table? Thanks!

let's say im assigning people to US states. US state data is available already in the customer table would it be better to create a US State table and have a field for the sales people assigned to the states? If CA had two salespeople, should there be a field for each sales person?

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

For some reason, when the column with the dates are past August 14, 2016, the formula returns #div/0 when there are most definitely dates still within 8 days in previous rows. Why might this be happening? advanced thanks.

thanks for quadrupling my productivity :D

i attached a screen capture using example data

hi stopher, thanks for your reply. your function seems to only be extracting the 2nd upper case latter in the target cell. There are other uppercase letters in the target cell as well, the only thing that distiguishes a state is that it consists of 2 consecutive upper case letters.

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!

Hi, I've attached a simplified version of my problem. Basically I would like the redundant customer names to be reduced to one.

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

Is it possible? The function seems to only work when creating a query. I'd like for the field to autopopulate and not necessitate running a query each time I append new records to a table. Thanks!

I only have one addition inquiry about this query. Using MAX in this query will return what product was ordered the most in 1 single order right? If I wanted to determine the most popular product sold throughout the year, would I use SUM in the subquery?

what if, I wanted to return the best selling product for each customer only for products where in a corresponding products table, a specific field (i.e. color) is Not Null? i tried adding the products table in the subquery and adding the Color field, setting criteria to Is Not Null, but in the...

I have an orders table containing fields: customer, product, orderyear, revenue, quantity How can I query the best selling product for each customer this year? I tried setting max(product), but it returned incorrect products.