Search results for query: *

I'm not sure my question was very clear. If a user enters a given number in cell A1, I need a formula in cell C1 that automaticlly uses the sum function to sum the values in column B. The sum function will always start at cell B1 but the ending cell will be dependant upon the value entered by...

In Excel, I need a formula that will lookup the value entered in cell A1, then sum the values of B1:B whatever the number entered in cell A1 was and place the result in Cell C1. For example: A user entered then value 20 in cell A1. Cells B1:B500 have data. I want a formula that will...

I tried it and got the following: upc StoreCount WeeksScanned UnitsSold 1 1 1 5 1 1 1 2 1 1 1 3 1 1 1 7 1 1 1 3 1 1 1 5 Again, I need the query to return in this case 1 record that should read: 1, 2, 3, 25 as results...

Bob, Thanks for the reply....The query does not produce the correct values for WeeksScanned and StoreCount. Based on Example above, results shoud be as follows: UPC, Store Count, Weeks Scaned, Units Sold 001, 2, 3, 25 I get the following when I run the query above: UPC, Store Count, Weeks...

I have a table called Scan Sales that contains the following fields: UPC, StoreID, WeekID, Units Sold I want to create a query that will count the number of weeks a UPC has sold and also count the number of stores the upc sold in. Data looks like this: UPC, StoreID, WeekID, Units 001, 50...

I put it back in and get the same message "Operation must use a updateable query." Query now looks like this... UPDATE RawData T SET T.UPC = (Select UPC From RawData X Where X.LastScanDate = (Select MAX(LastScanDate) From RawData Y...

OK. Now it says "Operation must use a updateable query." Here's the new query.... UPDATE RawData T SET T.UPC = (Select UPC From RawData X Where X.LastScanDate = (Select MAX(LastScanDate) From RawData Y Where...

Here it is... UPDATE RawData T SET T.UPC = (Select UPC From RawData X Where X.LastScanDate = (Select MAX(LastScanDate) From RawData Y Where Y.UPC = T.UPC AND Y.ItemCode <> 0)) From...

I get a syntax error(missing operator) in query expresion. The cursor blinks on the From Tbl T statement. I replaced tbl with RawData....Any clue?

Golom, My table that contains this data is called RawData. I don't see a reference to it. Is it tbl X or Y or T? Or do I not even need to mention it? thanks!

I have a table called RawData that contains the following fields and data looks like this: UPC, Item Code, Last Scan Date 500,001,4/19/2004 501,001,3/2/2002 200,0,4/18/2004 300,0,4/18/2004 I want to build a update query that will look for duplicates on Item Code if Item Code is greater than...

I get the following error when I try to open my db. "The MicroSoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." I was updating a query when acess 2003 stopped responding and I rebooted the pc. Now I get this...

I have a table called RawData that contains 2.5M records. The table has 3 fields that I need to use. Field 1 = UPC, Field 2 = Item Code, Field 3 = Last Scan Date. Some of the fields contain old UPC codes that I want to replace with the correct UPC codes. I want to construct a query that will...

Bob, I just tried the SQL and it works perfect! Thanks for taking the time to help!

I have 4 tables (Products,Dates,Stores,Sales). The products table contains the primary key UPC along with other fields. The Dates table contains primary Key WeekID along with other fields. The Stores table contains StoreID primary Key along with other fields. And the Sales table contains...

That did it! It works perfect! There a reason your at the top of the list! Thanks sooooo much for the help!

Golom, I want the query to pick the correct Brand and Description if there is a duplicate UPC based off the MAX Gen Code. It currently does that. For any duplicate records, based on UPC Code 12, I want the query to SUM all the sales fields for the duplicates. For Example: UPC Code 12,GEN...

Golom, Thanks for the trip. Question, I killed the sub queries and everything works except the Sum's and Max's. For example, The Dataset I ran had 155 records. There were only 3 duplicates based on UPC Code 12. The results returned 152 records and picked the correct values based off Gen...

I have a append query that runs great when there is 500 records but boggs down when there are more than 1000 records. Here's what the query does. Fields: Gen Code, UPC12, Brand, Description, Sales, ACV. There are about 40 fields for sales. They are different time frames. The query does a...

Simple index correction.