Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SanAntonioSpurFan

    Sum a Range based on Cell Value Entered

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

    Sum a Range based on Cell Value Entered

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

    Design a Query to Count

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

    Design a Query to Count

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

    Design a Query to Count

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

    Design Query to Update a Field

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

    Design Query to Update a Field

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

    Design Query to Update a Field

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

    Design Query to Update a Field

    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?
  10. SanAntonioSpurFan

    Design Query to Update a Field

    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!
  11. SanAntonioSpurFan

    Design Query to Update a Field

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

    The MicroSoft Jet databse engine stopped the process..

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

    Proper Query Setup

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

    Proper Query Construction

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

    Proper Query Construction

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

    Query boggs down with large datasets

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

    Query boggs down with large datasets

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

    Query boggs down with large datasets

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

    Query boggs down with large datasets

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

    Data Type Conversion Error - Make Member Procedure

    Simple index correction.

Part and Inventory Search

Back
Top